ALL_COL_PENDING_STATS describes the pending statistics of the columns accessible to the current user.
DBA_COL_PENDING_STATS describes the pending statistics of all columns in the database.
USER_COL_PENDING_STATS describes the pending statistics of the columns owned by the current user. This view does not display the OWNER column.
| Column | Datatype | NULL | Description |
|---|---|---|---|
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 |
Density of the column | |
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 |