1z0-417 Free Dumps Study Materials
Question 3: 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.
Correct Answer: F