Oracle
1Z0-054 · Question #1
After running SQL Performance Analyzer (SPA), you observe a few regressed SQL statements in the SPA output. Identify the two actions that you would suggest for these regressed SQL statements…
The correct answer is B. Adding them to SQL Plan Baseline C. Submitting them to SQL Tuning Advisor. See the full explanation below for the reasoning.
Question
After running SQL Performance Analyzer (SPA), you observe a few regressed SQL statements in the SPA output. Identify the two actions that you would suggest for these regressed SQL statements. (Choose two.)
Options
- ARunning SQL Access Advisor
- BAdding them to SQL Plan Baseline
- CSubmitting them to SQL Tuning Advisor
- DRunning Automatic Database Diagnostic Monitor (ADDM)
How the community answered
(51 responses)- A8% (4)
- B76% (39)
- D16% (8)
Community Discussion
No community discussion yet for this question.