10.121 V$TABLE_ACCESS_STATS
V$TABLE_ACCESS_STATS
displays the scan count for tables and partitions.
The scan data collection begins at instance startup.
Column | Datatype | Description |
---|---|---|
|
|
Object ID of the table or partition |
|
|
Aggregated scan count since instance startup |
|
|
Date and time of the most recent scan |
|
|
The ID of the container to which the data pertains. Possible values include:
|
Note:
This view is available starting with Oracle Database 23ai.