Tuning PL/SQL with Steven Feuerstein

With a focus on improving performance (i.e. tuning PL/SQL), Oracle ACE Director Steven Feuerstein gives you a whirlwind tour of some of the most exciting features of PL/SQL, including FORALL, BULK COLLECT, pipelined table functions and DBMS_UTILITY.FORMAT_ERROR_BACKTRACE.

This free training is segmented into several separate lessons:

  1. Using PL/SQL BULK COLLECT to Improve Performance (14:06)
    In this lesson, Oracle ACE Director Steven Feuerstein sets the agenda, introduces 4 techniques for improving the performance of your PL/SQL code AND demonstrates how to use BULK COLLECT.
  2. Tuning PL/SQL with the FORALL Statement (8:03) (click on video below)
    In this lesson, Steven demonstrates how to use FORALL in PL/SQL to increase performance.
  3. Tuning PL/SQL with Collections and the Function Result Cache (13:01)
    In this lesson, Steven Feuerstein demonstrates how to improve PL/SQL performance by caching data in PL/SQL package-based Associate Array Collections (collection cache) and by using the Function Result Cache (introduced in Oracle 11g).
  4. Finding Dead Code and Pipelined PL/SQL Functions (17:24)
    In this lesson, Oracle ACE Director Steven Feuerstein demonstrates how to use Oracle PL/SQL Compiler to locate – and remove – PL/SQL code that is never executed (i.e. dead code). Steven also demonstrates the “format error backtrace” function to report the precise line number that an error occurred. Finally, Steven demonstrates improving PL/SQL performance with pipelined table functions.

Date: Jan 26, 2011

NOTE: Some corporate firewalls will not allow videos hosted by YouTube.