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