448: Performance Tuning By Example: Oracle’s RMS Is The Tutor
Roger Ruckert , Ruckert, Inc.    Biography

Objectives: Knowing how to read a TKPROF output file to triage a performance problem
Knowing how to break down a driving cursor into smaller units of work
Knowing when increasing the number of threads will speed up or slow down performance
Abstract: Oracle’s RMS (Retail Merchandising System, formerly Retek Merchandising System) system consists of online forms and batch jobs. In most shops, the RMS batch window runs while the online users are locked out. As companies become more global, online access is needed for longer periods of time, and the batch window needs to be as small as it can be. This business requirement means that the batch jobs need to execute as efficiently as possible, which is a real challenge for the performance analyst.

This presentation will discuss some of the most common performance problems of these batch jobs, as well as their suggested solutions. Although the examples are from RMS, the performance tuning examples have broad applicability across Pro*C, Java, and PL/SQL programs.

Some of the issues covered will be SQL tuning of individual statements; how to recognize when adding more threads to a program will improve performance and when it will hurt; and when to decompose a large driving cursor i

Audiernce Focus: Developers
Expertise: Advanced
Track: Development
Date: Wednesday, April 16, 2008
Time: 11:00 AM - 12:00 PM