Oracle SQL Peformance Tuning

This course is designed for SQL programmers, Application Designers/Developers and Technical Support professionals who are required to monitor and tune the performance of an Oracle application.

Course Content

Tuning Database Applications for Optimal Performance
Managing Statistics
Creating and Using Indexes
Creating and Using Views
Structuring SQL Statements for Performance
Using the SQL Optimizers
Examining the Execution Plan of a SQL Statement using EXPLAIN PLAN
Examining the Efficiency of SQL Statements using SQL Trace and Autotrace
Using Hints to Influence Execution Plan
Identifying Unused Indexes
PL/SQL Tuning Issues

Skills

By the end of the course, the delegate will be able to:
Tune applications for optimal performance
Optimize SQL queries for faster access
Tune code to reduce disk I/O and reduce network traffic