Skip to Main Content

Feature Details

Buttons

Feature Details Container

Dynamic Performance Views for Table and Partition Access Tracking

Application Development → General

Read access to tables and partitions is tracked with a new dynamic performance view [G]V$TABLE_ACCESS_STATS and exposed in a user-friendly manner as data dictionary views [DBA | ALL | USER]_TABLE ACCESS_STATS, providing a deeper understanding of the access frequency of tables and individual partitions.

Business Benefit: Allowing the user to see how often tables and individual partitions are read enables you to understand the importance and frequency of your data for better assessment of your lifecycle management of your data.

Release Availability
11.2
12.1
12.2
18c
19c
21c
26ai
Available On
All Offerings
Initial Release
26ai