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.
|
