1. Database Reference
  2. Static Data Dictionary Views
  3. Static Data Dictionary Views: ALL_PART_COL_STATISTICS to DATABASE_PROPERTIES
  4. ALL_TAB_PENDING_STATS

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_COUNT

NUMBER

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

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

IM_BLOCK_COUNT

NUMBER

Number of In-Memory blocks in the table.

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

SCAN_RATE

NUMBER

Scan rate for the table in megabytes per second. This statistic is only relevant or meaningful for external tables.

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

SAMPLE_SIZE

NUMBER

Sample size

LAST_ANALYZED

DATE

Time of last analyze operation

See Also: