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
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
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.