[bbk5336] 第81集 第10章 SQL Performance 02

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