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 PL/SQL Application Tuning.
Oracle Training Prerequisites
- The course Introduction To Oracle9i SQL
- The course Introduction To Oracle9i Advanced SQL
- The course Introduction To Oracle9i PL/SQL Language
- The course Oracle9i Architecture for Developers
- The course Oracle9i SQL Tuning
Oracle Training Audience
Oracle application developers
Oracle Training Course duration
4 Days
Oracle Training Course outline
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
