| Oracle® Database Reference 11g Release 2 (11.2) Part Number E25513-03 | 
 | 
| 
 | PDF · Mobi · ePub | 
ALL_TAB_PENDING_STATS describes pending statistics for tables, partitions, and subpartitions accessible to the current user.
DBA_TAB_PENDING_STATS describes pending statistics for tables, partitions, and subpartitions in the database.
USER_TAB_PENDING_STATS describes pending statistics for tables, partitions, and subpartitions 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 | |
| NUM_ROWS | NUMBER | Number of rows | |
| BLOCKS | NUMBER | Number of blocks | |
| AVG_ROW_LEN | NUMBER | Average row length | |
| SAMPLE_SIZE | NUMBER | Sample size | |
| LAST_ANALYZED | DATE | Time of last analyze operation |