Prev Question
Next Question

IT Operations had observed short CPU spikes and I/O storms prior to a retail website outage. Which
functionality of Diagnostics Pack for Oracle Databases would you implement to diagnose and resolve the
customers issue?

A. Active Workload History to collect SQL at the time of its execution.

B. SQL Performance Analyzer to capture the information in the SGA, the sessions active, and analyze the
SQL executing.

C. Oracle Workload Advisor that automatically turns on and captures the offending SQL Statements when
thresholds are reached.

D. Active Session History to capture sessions and dump the SQL executing, performance attributes and
relevant information into a buffer for analysis.

E. Active SQL History Analyzer to do perform a comparison of SQL statements before and after.

F. Oracle Exadata, as it already includes Diagnostic Pack for Oracle Database.

Explanation:

Prev Question
Next Question

Leave a Reply

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