Track Table and Partition Scan Access with Autonomous Database Views

Oracle Autonomous Database tracks the scan count for tables and partitions. Use the table access stats data dictionary and dynamic views to retrieve scan count information.

GV$TABLE_ACCESS_STATS and V$TABLE_ACCESS_STATS Views

The GV$TABLE_ACCESS_STATS and V$TABLE_ACCESS_STATS views list the scan count for tables and partitions. The scan data collection begins at instance startup time.

Column Datatype Description
READ_COUNT NUMBER

Aggregated scan count since instance startup

OBJECT_ID NUMBER

Object ID of the table or partition

INST_ID NUMBER

Instance number where table/partition was scanned

This column (INST_ID) is only shown in GV$TABLE_ACCESS_STATS

CON_ID NUMBER

Container ID of the database

ALL_TABLE_ACCESS_STATS and DBA_TABLE_ACCESS_STATS Views

The ALL_TABLE_ACCESS_STATS and DBA_TABLE_ACCESS_STATS views list the scan count for tables and partitions. The scan data collection begins at instance startup time.

Note

The ALL_TABLE_ACCESS_STATS and DBA_TABLE_ACCESS_STATS views do not list scan count information for Oracle-maintained schemas.
Column Datatype Description
TABLE_OWNER VARCAR2(128)

Owner of the table

TABLE_NAME VARCAR2(128)

Name of the table

PARTITION_NAME VARCAR2(128)

Name of the partition

A NULL value specifies a non-partitioned table

INSTANCE_ID NUMBER

Instance number where table or partition was scanned

READ_COUNT NUMBER

Aggregated scan count since instance startup

USER_TABLE_ACCESS_STATS View

The USER_TABLE_ACCESS_STATS view lists the scan count for the user's tables and partitions. The scan data collection begins at instance startup time.

Column Datatype Description
TABLE_NAME VARCAR2(128)

Name of the table

PARTITION_NAME VARCAR2(128)

Name of the partition

A NULL value specifies a non-partitioned table

INSTANCE_ID NUMBER

Instance number where table/partition was scanned

READ_COUNT NUMBER

Aggregated scan count since instance startup