A naukri.com initiative
Dev
2w
286
Image Credit: Dev
Oracle 23ai — Track Table and Partition Scan Access
- Oracle 23ai introduces a new view named [dba|all|user]_table_access_stats.
- The new view allows users to view the access history of tables and partitions.
- The view shows the number of times each table or partition has been scanned, and the last time a table was accessed.
- The view provides valuable insights into table and partition access patterns and can help optimize performance.
Read Full Article
17 Likes
For uninterrupted reading, download the app