Oracle Database 10g PL/SQL Application Tuning

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.

Target audience

Oracle application developers. Students should have attended the following courses or have equivalent knowledge and/or experience:

• Oracle Database 10g Introduction to SQL
• Oracle Database 10g: Program With PL/SQL
• Oracle Database 10g: Architecture for Developers
• Oracle Database 10g: SQL Tuning

Course content

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

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