Oracle
1Z0-417 · Question #71
For which use case would you utilize SQL Performance Analyzer and optimizer pending statistics functionality?
The correct answer is C. to test effect of new Optimizer statistics. See the full explanation below for the reasoning.
Question
For which use case would you utilize SQL Performance Analyzer and optimizer pending statistics functionality?
Options
- Ato test performance after an upgrade to an Oracle Real Application Cluster
- Bto test performance of an Operating System patch
- Cto test effect of new Optimizer statistics
- Dto test performance after a database upgrade
- Eto test performance just after a database reboot
How the community answered
(31 responses)- A3% (1)
- B10% (3)
- C77% (24)
- D6% (2)
- E3% (1)
Community Discussion
No community discussion yet for this question.