Automated SQL Tuning
Starting with Oracle Database 11g and higher, Oracle provides several tools that help automate the SQL tuning process. This chapter focuses on the following automated SQL tuning tools:
- Automatic SQL Tuning Advisor
- SQL tuning sets (STS)
- Tuning task feature
- SQL Tuning Advisor
- Automatic Database Diagnostic Monitor (ADDM)
The Automatic SQL Tuning Advisor is a preset background database job (11g and higher) that by default runs daily. This task examines high resource-consuming statements captured in the Automatic Workload Repository (AWR) and generates tuning advice (if any) for each statement analyzed. As part of ...