Delegates: |
|
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. |
Objectives: |
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
|
Topics Covered:
|
|
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
|
Requirements:
|
|
A working knowledge of SQL and is required. This can be obtained by attendance on the pre-requisite course.
|
