1Z0-060 · Question #227
Identify the category of recommendation that can be implemented automatically by the Automatic SQL Tuning Advisor.
The correct answer is A. creating SQL profiles. The Automatic SQL Tuning Advisor (ASTA) runs during scheduled maintenance windows and is the only Oracle tuning feature that can both recommend AND automatically implement a change: accepting SQL profiles. A SQL profile stores supplemental optimizer statistics for a specific…
Question
Identify the category of recommendation that can be implemented automatically by the Automatic SQL Tuning Advisor.
Options
- Acreating SQL profiles
- Brestructuring SQL statements
- Ccreating invisible indexes
- Dreducing wait events
- Epartitioning a table
How the community answered
(40 responses)- A90% (36)
- B5% (2)
- C3% (1)
- D3% (1)
Explanation
The Automatic SQL Tuning Advisor (ASTA) runs during scheduled maintenance windows and is the only Oracle tuning feature that can both recommend AND automatically implement a change: accepting SQL profiles. A SQL profile stores supplemental optimizer statistics for a specific query, and if ASTA determines the profile yields a 3x or greater performance improvement, it automatically accepts it without DBA intervention. All other recommendation types - restructuring SQL statements (B), creating indexes (C), reducing wait events (D), and partitioning tables (E) - are advisory only; a DBA must manually review and implement them. Wait event reduction (D) is also outside the SQL Tuning Advisor's scope entirely; that falls under the SQL Access Advisor or manual tuning.
Topics
Community Discussion
No community discussion yet for this question.