- 03 Oct, 2022
- 0 Comments
- 41 Secs Read
How to generate ADDM report
How to generate ADDM report
Automatic Database Diagnostic Monitor(ADDM) can analyze performance issues during a particular period and provide suggestion. An ADDM analysis is performed on a set of awr snapshots. addmrpt.sql script is used to generate addm report.
It will ask for begin snap_id and end snap_id
To get snap id Execute below query :
Generate ADDM report:
1 2 | cd $ORACLE_HOME/rdbms/adminSQL>@addmrpt.sql |
1 | select DBID, INSTANCE_NUMBER, SNAP_ID, BEGIN_INTERVAL_TIME from DBA_HIST_SNAPSHOT; |
1 | SQL> @addmrpt.sql |
Privileges required for non-sys users to generate addm report:
1 2 3 4 | sqlplus / as sysdbaGRANT ADVISOR TO REPORT_USER;GRANT SELECT_CATALOG_ROLE TO REPORT_USER;GRANT EXECUTE ON dbms_workload_repository TO REPORT_USER; |