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
