Oracle SQL Performance Tuning Tips and Techniques - 3 Days
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 as well as covering a variety of Oracle Server tuning topics.
- Understanding SQL Tuning Statement Topics
- Reading Explain Plans/Understanding how Oracle arrives at Explain Plans
- Controlling the Cost-based Optimizers via coding techniques
- Oracle Trace Facility/Stats Pack/Wait Events and PL/SQL Profiler covered
An optional 3rd day of Advanced Tuning Topics includes Oracle 10g tablespace issues, finding/solving performance issues via V$ tables, statspack, and Oracle Trace.
- Item #: dh-09
