There are no prerequisites for this course.
|:||Download Training Details|
Advanced Oracle SQL tuning is an intensive three-day, four-day, or five-day course designed to provide Oracle professionals with an in-depth understanding of Oracle SQL tuning and how to formulate and tune SQL statements for optimal performance.
The goal of the SQL tuning class is to provide a comprehensive toolkit to allow the DBA to quickly locate and tune a database workload.
By the end of this course the student will be able to tune advanced SQL queries including correlated subqueries and outer joins. The student will also become familiar with all of the major SQL tuning techniques for Oracle, including global parameter and statistics changes, adding missing indexes and adjusting optimizer statistics. The student will also see the internals of the Oracle optimizers, and see proven techniques for tuning Oracle SQL statements for optimal performance.
This course is designed for practicing Oracle DBA's and Systems Administrators professionals who have basic experience with SQL statements. Prior experience with Oracle is not required, but experience using SQL with a relational database is highly desirable.
Introduction to SQL Tuning
Internal processing of SQL statements
Optimizer modes and goals
Execution plan internals
Oracle parallel query and parallel DML
Exposing execution plans
Tuning SQL with hints
Oracle Index Optimization
Tuning Oracle sorting
Advanced SQL Tuning Topics
Monitoring SQL Performance
Oracle DML Tuning
Tuning with materialized views and temporary objects
Troubleshooting bad SQL
Advanced Optimizer Statistics
Tuning Distributed SQL
Tuning with partitioning
Time-series SQL Tuning
Row re-sequencing for SQL performance