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 comment

I’m Yuan

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

My 20 Oracle Certifications

A screenshot from certview.oracle.com

My Book

MySQL 8.0 Operations and Optimization

Let’s connect