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.
|
Download Printable PDF. VALID exam to help you PASS. |
 |