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 theSQL executing.
C.
Oracle Workload Advisor that automatically turns on and captures the offending SQL Statements whenthresholds are reached.
D.
Active Session History to capture sessions and dump the SQL executing, performance attributes andrelevant information into a buffer for analysis.
E.
Active SQL History Analyzer to doperform a comparison of SQL statements before and after.
F.
Oracle Exadata, as it already includes Diagnostic Pack for Oracle Database.
D