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