3.116 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_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(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_COUNTFoot 1

NUMBER

  

Number of In-Memory Compression Units (IMCUs) in the table.

IM_BLOCK_COUNTFootref 1

NUMBER

  

Number of In-Memory blocks in the table.

SCAN_RATEFootref 1

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

Footnote 1

This column is available starting with Oracle Database 12c Release 2 (12.2.0.1).

See Also: