Oracle PL/SQL Tuning with Tim Hall May 17, 2010

This presentation contains everything you need to know about performance tuning of PL/SQL applications.

The program starts by introducing the current best practices for PL/SQL performance, many of which can be implemented in existing applications and result in "quick fixes" for performance problems. Each case is illustrated with a simple example demonstrating the performance improvements associated with the best practice.

Then, then more complex best practices, such as array processing, data caching and memory management are covered in greater detail, allowing the attendees to understand not only the technicalities, but also the practical implications of using such methods.

Alternative methods for packaging and presenting data are discussed, including cursor variables and REF CURSOR types, along with table functions and pipelining.

The methods of monitoring and profiling PL/SQL to identify problem code are demonstrated, so that performance tuning can be focused onto the areas where it is most needed.

In addition to performance related material, there is an explanation of the new features available to PL/SQL developers in Oracle 11g.

By the end of the seminar attendees will be confident they can identify what they need to do to bring ailing PL/SQL applications up to date, as well as making sure new application are "right first time".

Official Website: http://cli.gs/LHJ7LP