| Oracle SQL Performance Tuning Tips & Techniques - 2 Days |
Give your technical staff that competitive edge with this local Oracle Workshop. This course is designed for the Oracle professional with novice or no SQL tuning skills.
The focus of this tuning course is to illustrate coding techniques that insure a consistent response time between instances and releases of the Oracle database. This course works closely with performance tuning of actual SQL statements.
This course supports Oracle databases up through and including Oracle19c SQL tuning topics.
The course starts out with a complete overview of the Oracle architecture so students can get an understanding how their SQL and applications can take advantage of the computing environment. This course goes in-depth on understanding and controlling the explain plan (how Oracle retrieves data and in what order). The discussion includes considerable detail, with SQL examples, on how the optimizers (both rule-based and cost-based but mostly cost-based) make their decisions. Students will work with a variety of SQL statements, reviewing explain plans and making changes to make these SQL statements perform better. Lectures include index design, using hints and coding style to control the explain plans, and how to use useful tools such as index monitoring, SQL Trace, and the PL/SQL profiler. This course takes a close look at indexes: how Oracle selects them, why they are sometimes not used, and how to tell if indexes are being used/not being used.
Dan says: “I feel the Indexing part of this course is worth the cost of the course alone!”
The focus of this course is tuning SQL via coding style. The instructor finds that tuning in this fashion maintains the performance of the SQL when migrating to other Oracle environments (upgrades to newer releases).
Lectures and topics are enhanced with live illustrations and hands-on exercises |