Performance Optimization for PL/SQL


The course is organized into the following segments:

  • Welcome and Introduction
    Course welcome, agenda review, instructor and student introductions, SQL optimization overview (what you should already know).

  • PL/SQL Basics
    Introduction to PL/SQL, PL/SQL architecture, PL/SQL elements overview, PL/SQL memory management and PL/SQL compilation.

  • PL/SQL Performance Testing, Code Instrumentation and Tracing
    PL/SQL performance testing basics, code instrumentation including use of DBMS_SESSION, DBMS_SYSTEM and DBMS_APPLICATION_INFO supplied packages, the Hotsos Instrumentation Library for Oracle, tracing PL/SQL including the use of DBMS_TRACE and DBMS_PROFILER, the Hotsos SQL Test Harness.

  • PL/SQL Coding Techniques: Writing PL/SQL Right
    Efficient code logic ordering, implicit vs. explicit cursors, datatype issues, bind variables, cursor sharing, collections, bulk operations, REF CURSOR types and cursor variables, table functions, pipeline functions, and more.

  • Conclusion
    Course wrap-up, what have you learned this week and what's next?

Target Audience

The course is designed for Oracle database application developers and database administrators who wish to deepen their knowledge and skill level for optimizing the performance of Oracle PL/SQL code.


Before coming to class, please register for an account at

Students are expected to have a strong working knowledge of Oracle, Oracle SQL and PL/SQL and experience as a database administrator or application developer. We encourage students to have previously attended our Optimizing Oracle SQL course or have comparable experience and knowledge of the topics covered in that course.

To maximize the value of the course, we strongly recommend the following pre-course reading:

  • Oracle Database Server Concepts Guide
    Students are expected to be familiar with the content of the Concepts guide for a relevant Oracle release. Material is available online, free of charge, at the Oracle Database Documentation Library. It is listed as "Concepts" in the Getting Started section.
  • Oracle PL/SQL User's Guide and Reference
    Students are expected to be familiar with the content of this document for a relevant Oracle release. This materials is also available online, free of charge, at the Oracle Database Documentation Library.

Instructional Format

The three-day course is approximately 50% lecture, 50% hands-on exercises to strengthen understanding of the course material. The course is conducted in English.


Each student receives the following materials:

  • Course Notebook
    A printed copy of all the presentation slides used in the course.

  • Tools
    Access to course exercise setup and solution files, software tools and scripts, and supplemental documentation at

Class Forum

For questions and discussion about the course, please visit our forum.


  • List Price: $1875.00
  • Alumni Price: $500.00*
    *Alumni pricing is available to prior attendees of this course.


Please visit our Calendar of Events to find when this course will be offered next.