ADDM (Automatic Database Diagnostic Monitor) Report Generates a Three-Day Report

 

ADDM (Automatic Database Diagnostic Monitor) Report Does Not Ask for Number Of Days to Report Upon and Automatically Generates a Three-Day Report (Doc ID 2059948.1)

 

You can do this as follows:

Note: you will need suitable operating system permissions on the $ORACLE_HOME/rdbms/admin/ directory to write the files, alternatively copy them to a different location.

1. Make a backup copy of the original script which resides in $ORACLE_HOME/rdbms/admin/addmrpt.sql using a suitable operating system command e.g.:

$ cp $ORACLE_HOME/rdbms/admin/addmrpt.sql $ORACLE_HOME/rdbms/admin/addmrpt.sql.bak

2. Open the $ORACLE_HOME/rdbms/admin/addmrpt.sql script for editing
3. Modify the customer configurable variable num_days so that it reflects the number of days worth of snapshots that you want to see. For example, to see 5 days change the value to 5:

define num_days = 5;

 
Alternatively, commenting the line out will result in all snapshots being displayed (caution: this may be a long list):

-- define num_days = 3;

 

4. Save the file
5. Execute the customized report