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

SAMPLE_SIZE

NUMBER

  

Sample size

LAST_ANALYZED

DATE

  

Time of last analyze operation

See Also: