Track Table and Partition Scan Access with Autonomous AI Database Views
Oracle Autonomous AI 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 ( |
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 |
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 |
INSTANCE_ID |
NUMBER |
Instance number where table/partition was scanned |
READ_COUNT |
NUMBER |
Aggregated scan count since instance startup |