At 6:00 p.m. you notice that the database performance was slow between 2:00 p.m. and 6:00 p.m. due to a series of interrelated problems. You plan to use the Automatic Database Diagnostic Monitor (ADDM) findings for the time period 2:00 p.m. to 6:00 p.m. to resolve the performance issue. The Automatic Workload Repository (AWR) snapshots are made every 30 minutes.
What would you do?
Lock at the latest ADDM report.
Check the alert log to see if it contains ADDM advice.
Modify the time interval used by the DBMS_JOB.INTERVAL procedure
Check for the ADDM advice trace file in the BACKGROUND_DUMP_DEST directory
Modify the Automatic Workload Repository (AWR) snapshot retention period to four hours
Create a custom ADDM task over the period defined by the snapshots taken at 2:00 p.m. and 6:00 p.m.