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.
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.
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.
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
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