ALL_TAB_PENDING_STATS
ALL_TAB_PENDING_STATS describes pending statistics for tables, partitions, and subpartitions accessible to the current user.
Related Views
-
DBA_TAB_PENDING_STATSdescribes pending statistics for tables, partitions, and subpartitions in the database. -
USER_TAB_PENDING_STATSdescribes pending statistics for tables, partitions, and subpartitions owned by the current user. This view does not display theOWNERcolumn.
| Column | Datatype | NULL | Description |
|---|---|---|---|
OWNER |
VARCHAR2(128) |
Owner of the table | |
TABLE_NAME |
VARCHAR2(128) |
Name of the table | |
PARTITION_NAME |
VARCHAR2(128) |
Name of the partition | |
SUBPARTITION_NAME |
VARCHAR2(128) |
Name of the subpartition | |
NUM_ROWS |
NUMBER |
Number of rows | |
BLOCKS |
NUMBER |
Number of blocks | |
AVG_ROW_LEN |
NUMBER |
Average row length | |
IM_IMCU_COUNT |
NUMBER |
Number of In-Memory Compression Units (IMCUs) in the table. | |
IM_BLOCK_COUNT |
NUMBER |
Number of In-Memory blocks in the table. | |
SCAN_RATE |
NUMBER |
Scan rate for the table in megabytes per second. This statistic is only relevant or meaningful for external tables. | |
SAMPLE_SIZE |
NUMBER |
Sample size | |
LAST_ANALYZED |
DATE |
Time of last analyze operation |
See Also: