Using the SQL Tuning Advisor
- Use the SQL Tuning Advisor to analyze SQL statements and obtain performance recommedations
- Sources for SQL Tuning Advisor to analyze:
- Top Activety:Analyzes the top SQL statements currently active
- SQL Tuning Set:Analyzes a set of SQL statements you provide
- Historical SQL(AWR):Analyzes SQL statements from statements collected AWR snapshots.
SQL Tuning Advisor Options
SQL Tuning Advisor Recommendations
Using the SQL Tuning Advisor:Example
Duplicate SQL