CHAPTER 11SQL Optimization Techniquesin PeopleSoft

The previous two chapters discussed how to obtain the performance metrics that can indicate the most time-consuming processes or activities on your system. In the case of the Application Engine and COBOL processes, traces can identify the particular step in the process that is costing the most time. Although significant amounts of time can be spent executing code in the client or application server processes, you'll often find that the most time-consuming step turns out to involve the execution of SQL.

When SQL performance is not the most significant part of a performance issue, then the problem is likely to be much more complicated to address. It may come down to the design of a process, which ...

Get PeopleSoft for the Oracle DBA now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.