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
TheGV$TABLE_ACCESS_STATSandV$TABLE_ACCESS_STATSviews list the scan count for tables and partitions. The scan data collection begins at instance startup time. - ALL_TABLE_ACCESS_STATS and DBA_TABLE_ACCESS_STATS Views
TheALL_TABLE_ACCESS_STATSandDBA_TABLE_ACCESS_STATSviews list the scan count for tables and partitions. The scan data collection begins at instance startup time. - USER_TABLE_ACCESS_STATS View
TheUSER_TABLE_ACCESS_STATSview lists the scan count for the user's tables and partitions. The scan data collection begins at instance startup time.
Parent topic: Autonomous Database Views
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.
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 |