Prev Question
Next Question

The application workload on your database is same between 10 a.m. and 11 a.m. on weekdays.
Suddenly you observe poor performance between 10 a.m. and 11 a.m. in the middle of the week.
How would you identify the changes in configuration settings, workload profile, and statistics to
diagnose the possible causes of the performance degradation?

A.
by using the Automatic Workload Repository report

B.
by using the SQL access advisor

C.
by running the Automatic Database Diagnostic Monitor (ADDM)

D.
by analyzing the output of the V$ACTIVE_SESSION_HISTORY view

E.
by using the Automatic Workload Repository Compare Period report

Prev Question
Next Question

Leave a Reply

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