Oracle9I PL/SQL Application Tuning Course

The objective of this course is to allow PL/SQL developers to write efficient and tuned programs. Performance techniques, problem areas and troubleshooting tools are all presented. Please note: This course is alternately named Oracle9i Advanced PL/SQL Programming.

This course is designed for Oracle application developers.

Upon completion of this course, the participant will be able to:
> Write efficient and tuned programs

Understanding The Tuning Issues 

Using Tkprof & Autotrace 

Using The Statspack Utility
Setting Snampshot Levels & SQL Thresholds
Maintaining The Statistics Performance Tables

Exploiting & Managing Cursor Sharing 
Bind Variables & Cursor Peeking 
Using The Cursor_Sharing Parameter 

Using Cursor Variables 
Using Sys_Refcursor 

Invoking External Procedures 
Registering With The Database 
Oracle Net Configuration 

Advanced Program Units 
Using Invoker Rights 
Native Dynamic SQL 
Autonomous Transactions 

 Using Collections 
Bulk Bind Using Collections
Collection Methods 

PL/SQL Tuning With Dbms_Profiler() 
Installing DBMS_Profiler()
Using DBMS_Profiler() To Manage Runs 

Evaluating The PL/SQL Profiler Data
User Queries Of The Cross Run Tables
System-Supplied Cross Run Tables Queries

PL/SQL Tuning Techniques 
Using Nocopy For Parameters 
Using The Returning Clause 
Choosing The Optimum Datatype 
Useful PL/SQL Coding Techniques 

PL/SQL Debugging With Dbms_Trace() 
Installing DBMS_Trace() 
Using DBMS_Trace() To Manage Runs 

Examining The PLSQL_Trace_ ... Tables

Introduction To Oracle9i SQL
Introduction To Oracle9i Advanced SQL
Introduction To Oracle9i  PL/SQL Language
Oracle9i Architecture for Developers
Oracle9i SQL Tuning