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