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