1Z0-083 practice question 3 of 35

Choose three. Which are the three steps in the SQL tuning process for Oracle Database environments?

Full set: 286 questions
Answer options
A: Tune individual SQL statements using the SQL Tuning Advisor. Correct answer
B: Identify poorly tuned SQL statements using Automatic Database Diagnostic Monitor. Correct answer
C: Test the application as a whole using tuned SQL statements. Correct answer
D: Test tuned SQL statements one at a time for all statements in the application.
E: Identify poorly tuned SQL statements using the SQL Tuning Advisor.
F: Tune SQL statements as a group using the SQL Tuning and SQL Access Advisors.
Correct Answer:
A. Tune individual SQL statements using the SQL Tuning Advisor.; B. Identify poorly tuned SQL statements using Automatic Database Diagnostic Monitor.; C. Test the application as a whole using tuned SQL statements.
Explanation

The Oracle SQL tuning process follows a structured methodology. It begins with identifying high-load SQL statements, often using tools like the Automatic Database Diagnostic Monitor (ADDM) which analyzes workload data. The next step is to tune the identified individual statements, for which the SQL Tuning Advisor is a primary tool that provides recommendations. Finally, the tuned statements must be tested within the context of the entire application to validate performance improvements and ensure no negative side effects or regressions

Why Incorrect

D Testing every tuned SQL separately is not a distinct phase in the documented process. E SQL Tuning Advisor is a tuning tool; it is not used to locate problem SQL. F Group tuning is part of phase-2 already represented by A; the process only counts three phases.

References

1. Oracle Database 19c Performance Tuning Guide, Sec 3.2 “SQL Tuning Process” (Bulleted list of the three steps).

2. Oracle Database 19c Performance Tuning Guide, Table 3-1 (tools used in each step).

Scroll to Top