Programming & Tuning with Oracle PL/SQL – Advanced

4 day course

The objective of this course is to allow experienced PL/SQL developers to write efficient programs. Advanced techniques which not only improve execution speed but also enhance the functionality of the programs are also discussed. Topics covered include exploiting and managing cursor sharing, utilizing cursor variables, invoking external procedures, including dynamic SQL and other advanced programming techniques, efficiently executing dynamic SQL using bulk bind techniques, tuning with the DBMS_PROFILER() system-supplied package, debugging with the DBMS_TRACE() system-supplied package, and performance tuning and analysis of PL/SQL applications.

Overview of Course Topics:
(for a full detailed outline, visit our PDF link above)

• PL/SQL Development Support from EM
• Exploiting & Managing Cursor Sharing
• Dynamic SQL
• Using Collections
• Retrieving DDL with DBMS_METADATA()
• Advanced DBMS_METADATA() Processing
• Processing Dependent Objects with DBMS_METADATA()
• Redefining Tables with DBMS_REDEFINITION()
• Using Large Objects (LOBs)
• Advanced Interface Methods
• About PL/SQL Performance Tuning
• Using the Tuning Utilities
• Influencing Oracle PL/SQL Compilation
• PL/SQL Tuning with DBMS_PROFILER()
• Evaluation the PL/SQL Profiler Data
• PL/SQL Advanced Programming & Tuning
• PL/SQL Debugging with DBMS_TRACE()