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 ...

Get Oracle Database 12c Performance Tuning Recipes: A Problem-Solution Approach now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.