Automatic SQL tuning is exposed to the user through two new … has been significantly enhanced in Oracle Database 10g. Four types of analyses are performed in Automatic SQL Tuning: • … Oracle University |Contactati-ne: +4021 3072820 Oracle Database 10g: SQL Tuning Durata: 3 zile Ce veti invataÚ This course is designed to give the experienced SQL Developer or DBA a firm foundation in SQL tuning techniques. The participant learns the necessary knowledge and skills to effectively tune SQL in the Oracle Database 10g Release 2.

Automatic SQL Tuning Manual SQL tuning is a complex process that presents many challenges. It requires expertise in several areas, is very time consuming, and requires an intimate knowledge of the schema structures and the data usage model of the application. All these factors make manual SQL tuning a challenging and resource intensive task that is ultimately very expensive for businesses. Automatic SQL Tuning, a new solution that is part of the Oracle Tuning Pack 10g, is Oracle’s answer to all the pitfalls and challenges of manual SQL tuning. It automates the entire SQL tuning process by comprehensively exploring all the possible ways of tuning a SQL statement. It is performed by the database engine’s query optimizer, which has been significantly enhanced in Oracle Database 10g. Four types of analyses are performed in Automatic SQL Tuning: • Statistics Analysis : The query optimizer needs up-to-date object statistics to generate good execution plans. In this analysis objects with stale or missing statistics are identified and appropriate recommendations are made to remedy the problem. • SQL Profiling : This is new feature introduced in Oracle Database 10 g that revolutionizes the approach to SQL tuning. Traditional SQL tuning involves manual manipulation of application code using optimizer hints. SQL Profiling eliminates the need for this manual process and tunes the SQL

Download ORACLE TUNING PACK.Pdf