ADDM test note

ADDM is the abbreviation of diagic Database Diagnostic Moniter. You can regularly check the database status, automatically identify database performance bottlenecks, and provide adjustment measures and suggestions. The database collects workload snapshots every hour by default.
The steps for testing are as follows:
1. Run the following SQL statement, find the SNAP_ID of the time period you want to analyze, and write down the SNAP_ID corresponding to the two time periods.
SQL> SELECT SNAP_ID, BEGIN_INTERVAL_TIME, END_INTERVAL_TIME, SNAP_LEVEL, ERROR_COUNT FROM dba_hist_snapshot ORDER BY snap_id DESC;
2. Run @ $ ORACLE_HOME/rdbms/admin/addmrpt. SQL to generate a report.
During SQL running, the system first prompts you to enter the starting SNAP_ID, The SNAP_ID corresponding to the start time you noted down, And then requires you to enter the SNAP_ID corresponding to the stop time, enter a name. Oracle generates a report named after this name, such as test. lst.
3. Of course I have read this report.
Of course, you can also manually collect the workload snapshots automatically collected by oracle as needed. You need to execute dbms_workload_repository:
SQL> exec dbms_workload_repository.create_snapshot ('typical ');