Objectives
- After completing this lesson, you should be able to:
- Set up and modify Automatic SQL Tuning
- Use the PL/SQL interface to perform fine tuning
- View and interpret reports generated by Automatic SQL Tuning
Oracle Database 10g introduced SQL Tuning Advisor to help database administrators and
application developers improve the performance of SQL statements. The advisor targets the
poorly written SQL, in which SQL statements have not been designed in the most efficient
fashion. It also targets a SQL statement that is performing poorly (more common), because the
optimizer generated a poor execution plan due to a lack of accurate and relevant data statistics. In
all cases, the advisor makes specific suggestions for speeding up SQL performance, but it leaves
the responsibility of implementing the recommendations to the user.
In addition to SQL Tuning Advisor, Oracle Database 10g has an automated process to identify
high-load SQL statements in your system. This is done by the Automatic Database Diagnostic
Monitor (ADDM), which automatically identifies the high-load SQL statements that are good
candidates for tuning.
However, some issues still remained. Although ADDM identifies some SQL that should be
tuned, you must manually examine the ADDM reports and run the SQL Tuning Advisor on those
reports to perform the actual tuning.
© 2010, www.oracledatabase12g.com. 版权所有.文章允许转载,但必须以链接方式注明源地址,否则追究法律责任.
相关文章 | Related posts:
- Oracle Database 11g: High Availability Student Guide
- Oracle Database 11g: Program Development Student Guide
- Oracle Database 11g: New Features Overview eStudy Student Guide
- Oracle Database 11g: Diagnosability Student Guide
- Oracle Database 11g: Security Student Guide
- Oracle Database 11g: Scheduler Student Guide
- Oracle Database 11g: Java Development Student Guide
- Oracle Database 11g: BI and Data Warehousing Student Guide
- Performance Tuning Guide for Siebel CRM Application on Oracle
- Dumps,Crashes and Corruptions Student Guide
最新评论