About the course

By the end of the course, the specialist will be able to tune applications for optimal performance; optimize SQL*Plus queries for faster access and tune PL/SQL code to reduce disk I/O and reduce network traffic.

Audience

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

Prerequisites

A knowledge of SQL*Plus and PL/SQL is required.

Duration

2 days

Attendees who followed this course were also interested in:-

• Oracle Database 10g DBA - Part I
• PLSQL tuning and optimization in the Oracle 10G database
• Database performance tuning for Oracle 10G DBAs

Please note these events are suitable for specialists from earlier releases of Oracle.

• Tuning Database Applications for Optimal 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
  
• Using Parallel DML
  
• Structuring SQL Statements for Performance
  
• Creating and Using Indexes and Clusters
  
• Identifying Unused Indexes
  
• Managing Statistics
  
• PL/SQL Tuning Issues