Oracle 10g/11g SQL Statement Tuning
Duration: 3 Days
This course is designed to give students a foundation in SQL statement tuning. They are provided the necessary knowledge and skills to effectively tune SQL statements against the Oracle10g and 11g server. Students will focus on the Oracle Cost-Based Optimizer (CBO). The students learn to use the Oracle diagnostic tools and facilities: EXPLAIN, SQL*Plus AUTOTRACE, and other tools. Gathering and utilizing object and system statistics is covered in detail. In addition, the participants also learn to influence the behavior of the CBO by hinting and modifying physical database objects. The course content is largely applicable to users of Oracle 9i as well.
Topics Covered In This Course
Oracle???s SQL tools
The Petsaver database
Introduction to tuning
SQL statement processing
The Oracle optimizers
Optimizing SHARED_POOL utilization
Using the EXPLAIN PLAN utility
SQL*Plus tuning tools
Choosing the driving table in JOINS
Using Hints to influence the Optimizer
Who Should Take This Course
Experienced Oracle developers and application development support DBAs.
3 to 6 months of experience writing SQL in Oracle version 10 or 11.
Knowledge of SQL join syntax.
Lecture with frequent hands on labs.
Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.
You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.
Can't find the course you want?
Call us at 800.533.3893, or
email us at [email protected]