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