Oracle9i PL/SQL Application Tuning

The objective of this 4-day course is to allow PL/SQL developers to write efficient and tuned programs. Performance techniques, problem areas and troubleshooting tools are all presented

Target audience

This course has been developed for Oracle application developers. Students are recommended to have attended the following course or have the equivalent knowledge and experience:

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

Course content

Understanding the tuning issues

Using TKPROF & AUTOTRACE

Using the STATSPACK utility Setting SNAMPSHOT levels and SQL thresholds • Maintaining the statistics performance tables

Exploiting and managing cursor sharing Bind variables and 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

About Courseware Company :: Instructor-led training courseware :: Self-study solutions :: Buy online today