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.
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).
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.