Oracle10g SQL Tuning for Developers and DBAs

Learn to tune SQL statements with EXPLAIN PLAN, SQL Trace and TKPROF (and AUTOTRACE and CBO 10053 trace and Much More).

Your Oracle database has so much more to offer.

Have you learned about optimizer (CBO) features like bind variable peeking, histograms, dynamic sampling?

Do you know when hints should be used - and when they should not?

No? Then why expect your SQL statements to perform (and scale) well?

This hands-on course will provide you with the skills necessary to create scalable, high performance SQL-based Oracle applications (proactive SQL tuning). You will also learn how to identify existing high-load, poor performing SQL statements and tune them (reactive SQL tuning). Particular attention is paid to making the best use of Oracle architecture, bench-marking various SQL formulations and identifying the best schema object (e.g. heap table, IOT, etc.) for a given situation. Oracle10g introduces "automatic tuning" features such as the Automatic Workload Repository, Automatic Database Diagnostic Monitor and SQL Tuning Advisor. These features are covered in this class.

The course also includes a lesson on tuning PL/SQL programs. This includes using bulk processing and profiling to identify high-load statements.

Working examples are included throughout the course book. Students have access to electronic versions of all sample scripts and lab solutions. Approximately 50% of class time is spent on hands-on exercises.

As with all of our courses, this class is highly customizable to your specific training requirements. Hands-on workshops constitute approximately 50% of the class.