[bbk5329] 第79集 - 第10章 - SQL Performance 00

oracle的智能体现:oracle在AWR执行完成一次快照收集之后，ADDM会自动监控本次收集快照之后发现的影响性能的SQL或者其他组件，然后自动调用相应的Advisor进行分析，被报告出分析结果.

Objectives

After completing this lesson,you should be able to :

• Use the SQL Tuning Advisor to:
  • -Identify SQL statements that are using the most resources
  • -Tune SQL statements that are using the most resources
• Use the SQL Access Advisor to tune a workload

SQL Tuning

SQL tuning process

• Identify poorly tuned SQL statements.
• Tune the individual statements.
• Tune the application as a whole.

SQL Advisor

Automatic SQL Tuning Results

Implement Automatic Tuning Recommendations