OWNER |
VARCHAR2(30) |
|
Owner of the table |
TABLE_NAME |
VARCHAR2(30) |
|
Name of the table |
PARTITION_NAME |
VARCHAR2(30) |
|
Name of the partition |
SUBPARTITION_NAME |
VARCHAR2(30) |
|
Name of the subpartition |
COLUMN_NAME |
VARCHAR2(30) |
|
Name of the column |
NUM_DISTINCT |
NUMBER |
|
Number of distinct values in the column |
LOW_VALUE |
RAW(32) |
|
Low value in the column |
HIGH_VALUE |
RAW(32) |
|
High value in the column |
DENSITY |
NUMBER |
|
If a histogram is available on COLUMN_NAME, then this column displays the selectivity of a value that spans fewer than 2 endpoints in the histogram. It does not represent the selectivity of values that span 2 or more endpoints.
If a histogram is not available on COLUMN_NAME, then the value of this column is 1/NUM_DISTINCT.
|
NUM_NULLS |
NUMBER |
|
Number of NULLs in the column |
AVG_COL_LEN |
NUMBER |
|
Average length of the column (in bytes) |
SAMPLE_SIZE |
NUMBER |
|
Sample size used in analyzing the column |
LAST_ANALYZED |
DATE |
|
Most recent date on which the column was analyzed |
