Disclaimer

Wednesday, 13 October 2021

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

  1. Open the $ORACLE_HOME/rdbms/admin/addmrpt.sql script for editing
  2. 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;

 

  1. Save the file
  2. Execute the customized report





No comments:

Post a Comment

ORA-07445: exception encountered: core dump [qcpibfa()+235] [SIGSEGV] [ADDR:0x7FFF6A9C7C88] [PC:0x4BF0E4B] [Address not mapped to object

  After patching 19.26 , we received complain from Application team that they were facing below error while executing one particular SQL_ID ...