[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

 

 

posted @ 2013-06-04 12:34  ArcerZhang  阅读(97)  评论(0编辑  收藏  举报