Oracle Training : Oracle9i Advanced PL/SQL Programming

Oracle9i Advanced PL/SQL Programming

Oracle Training Overview

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