What would you do?

At 6:00 p.m. you noticed 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?

At 6:00 p.m. you noticed 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?

A.
Check the alert log to see if it contains ADDM advice

B.
Look at the latest ADDM report

C.
Modify the time interval by using the DBMS_JOB.INTERVAL procedure

D.
Modify the Automatic Workload Repository (AWR) snapshot retention period to four hours

E.
Check for the ADDM advice trace file in the BACKGROUND_DUMP_DEST directory

F.
Create a custom ADDM task over the period defined by the snapshots taken at 2:00 p.m.
and 6:00 p.m.

Explanation:



Leave a Reply 0

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