WA1382 Oracle Database 10g: Advanced PL/SQL Programming & Tuning Course Outline
 
1. PL/SQL DEVELOPMENT SUPPORT FROM EM
  • ABOUT EM & PL/SQL
  • MANAGING INVALID OBJECTS
2. EXPLOITING & MANAGING CURSOR SHARING
  • ABOUT CURSOR SHARING
  • BIND VARIABLES & CURSOR PEEKING
  • USING THE CURSOR_SHARING PARAMETER
3. DYNAMIC SQL
  • NATIVE DYNAMIC SQL
4. USING COLLECTIONS
  • ABOUT COLLECTIONS
  • BULK BIND USING COLLECTIONS
  • COLLECTION METHODS
5.RETRIEVING DDL WITH DBMS_METADATA()
  • WHY RETRIEVE OBJECT DEFINITIONS?
  • RETRIEVING DEFAULT METADATA
  • RETRIEVING CUSTOMIZED METADATA
6.ADVANCED DBMS_METADATA() PROCESSING
  • SET_TRANSFORM_PARAM()
  • GET_QUERY()
7. PROCESSING DEPENDENT OBJECTS WITH DBMS_METADATA()
8. REDEFINING TABLES WITH DBMS_REDEFINITION()
  • ABOUT TABLE REDEFINITION
  • USING THE DBMS_REDEFINITION() PACKAGE
9.USING OTHER SYSTEM-SUPPLIED PACKAGES
  • DBMS_DESCRIBE()
  • UTL_MAIL
  • DBMS_SCHEDULER()
10.USING LARGE OBJECTS (LOBS)
11. ADVANCED INTERFACE METHODS
  • ABOUT EXTERNAL PROCEDURES
  • REGISTERING WITH THE DATABASE
  • ORACLE NET CONFIGURATION
  • CALLING EXTERNAL PROCEDURES
12. ABOUT PL/SQL PERFORMANCE TUNING
  • ABOUT THE TUNING EFFORT
  • THE DIFFICULTY OF TUNING
  • THE SQL & PL/SQL EXECUTION ENVIRONMENT
  • THE IMPACT OF THE SYSTEMS INFRASTRUCTURE
13. USING THE TUNING UTILITIES
14.INFLUENCING ORACLE10G PL/SQL COMPILATION
  • PLSQL_WARNINGS
  • PLSQL_OPTIMIZE_LEVEL
  • PL/SQL NATIVE EXECUTION
15. PL/SQL TUNING WITH DBMS_PROFILER()
  • ABOUT DBMS_PROFILER()
  • INSTALLING DBMS_PROFILER()
  • USING DBMS_PROFILER() TO MANAGE RUNS
  • EXAMINING THE PROFILER TABLES
16. EVALUATING THE PL/SQL PROFILER DATA
  • ABOUT THE PROFILER DATA
  • USER QUERIES OF THE CROSS RUN TABLES
  • SYSTEM-SUPPLIED CROSS RUN TABLES QUERIES
17.PL/SQL ADVANCED PROGRAMMING & TUNING TECHNIQUES
  • AUTONOMOUS TRANSACTIONS
  • USING NOCOPY FOR PARAMETERS
  • CHOOSING THE OPTIMUM DATATYPE
  • USEFUL PL/SQL CODING TECHNIQUES
18.PL/SQL DEBUGGING WITH DBMS_TRACE()
  • ABOUT THE TRACE FACILITY
  • INSTALLING DBMS_TRACE()
  • USING DBMS_TRACE() TO MANAGE RUNS
  • EXAMINING THE PLSQL_TRACE_... TABLES