Knowledge Base >> Disable Oracle AWR

Disable Oracle AWR - Confio Article 1568

Confio Article: 1568 Published: Oct 12 2009 8:03 AM
Version: N/A Topic(s): Install and Setup Wait Time Analysis Database Problems Ignite Management Ignite Features
Product(s): Ignite
Database(s): Oracle

If you would like to disable AWR from executing on an Oracle database, here are several ways to turn it off.  If you are not using the AWR data, why pay the penalty for having it continually running and collecting unused data.  These steps are listed in what I think are the easiest options first.

  1. Set STATISTICS_LEVEL parameter to BASIC.
  2. Run the CATNOAWR.sql script to drop the AWR Repository tables.
  3. Execute DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS(interval=>0).
  4. Download dbms_awr.plb from Metalink, compile this package and execute the PL/SQL package DBMS_AWR.DISABLE_AWR() [see Metalink note 436386.1].
  5. This does not work for an existing database, but does for future databases: Create your own database creation scripts (do not utilize DBCA) and do not execute the CATAWRTB.sql script.
Tags: repository disable awr dbms_awr disable_awr catawrtb dbca statistics_level basic catnoawr dbms_awr.plb dbms_workload_repository modify_snapshot_setting