Without an Oracle Diagnostics Pack license, using AWR and ASH is illegal, even with an Enterprise Edition license. To ensure compliance with Oracle’s licensing requirements and prevent avoid unintentional use of AWR and ASH, consider the following methods:

  • Set CONTROL_MANAGEMENT_PACK_ACCESS to NONE: As demonstrated, this disables AWR and ASH data collection.
  • Set the hidden parameter _awr_restrict_mode to TRUE: This disables AWR snapshot creation entirely.
  • Disable AWR snapshots: set the snapshot interval to 0 to stop automatic snapshot creation:
EXEC DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS(interval => 0);

Note: Some Oracle features, like Automatic Segment Advisor and Undo Advisor, rely on AWR data internally but do not require a Diagnostics Pack license. Without AWR snapshots, these features can not function.

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