Auditing AWR Usage in Oracle

You can track whether AWR-related feature have been used by querying the DBA_FEATURE_USAGE_STATISTICS view:

SELECT name,
  detected_usages,
  currently_used,
  TO_CHAR(last_sample_date,'DD-MON-YYYY:HH24:MI') last_sample
FROM dba_feature_usage_statistics
WHERE name LIKE 'AWR %';

Sample output:

This output clearly shows which AWR features have been used and how often, aiding compliance audits.

Leave a Reply

I’m Yuan

Welcome to the blog of a database performance maven. Feel free to contact me to share and discuss database knowledge.

My Oracle Book

My 26 Oracle Certifications

A screenshot from certview.oracle.com

My MySQL Book

MySQL 8.0 Operations and Optimization

Let’s connect