ALL_COL_PENDING_STATS
describes the pending statistics of the columns accessible to the current user.
Related Views
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 of the table |
|
|
|
Name of the table |
|
|
|
Name of the partition |
|
|
|
Name of the subpartition |
|
|
|
Name of the column |
|
|
|
Number of distinct values in the column |
|
|
|
Low value in the column |
|
|
|
High value in the column |
|
|
|
If a histogram is available on If a histogram is not available on |
|
|
|
Number of NULLs in the column |
|
|
|
Average length of the column (in bytes) |
|
|
|
Sample size used in analyzing the column |
|
|
|
Most recent date on which the column was analyzed |
See Also: