Oracle
1Z0-417 · Question #87
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 correct answer is D. Active Session History to capture sessions and dump the SQL executing, performance attributes. See the full explanation below for the reasoning.
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?
Options
- AActive Workload History to collect SQL at the time of its execution.
- BSQL Performance Analyzer to capture the information in the SGA, the sessions active, and
- COracle Workload Advisor that automatically turns on and captures the offending SQL Statements
- DActive Session History to capture sessions and dump the SQL executing, performance attributes
- EActive SQL History Analyzer to do perform a comparison of SQL statements before and after.
- FOracle Exadata, as it already includes Diagnostic Pack for Oracle Database.
How the community answered
(40 responses)- A8% (3)
- B3% (1)
- C13% (5)
- D75% (30)
- E3% (1)
Community Discussion
No community discussion yet for this question.