Prev Question

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.

Prev Question

Leave a Reply

Your email address will not be published. Required fields are marked *