|
|
|
ORA05DEV-9i-04-SG
Oracle 9i Advanced PL/SQL Programming (4 Days)
Description
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 Oracle 9i PL/SQL Application Tuning.
Audience
Oracle application developers
Prerequisites
• The Sideris course Introduction To Oracle 9i SQL
• The Sideris course Introduction To Oracle 9i Advanced SQL
• The Sideris course Introduction To Oracle 9i PL/SQL Language
• The Sideris course Oracle 9i Architecture for Developers
• The Sideris course Oracle 9i SQL Tuning
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
|
|
|
|
|
