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: