CHAPTER 10PeopleTools PerformanceUtilities

In PeopleTools 8.4, PeopleSoft has started to introduce some utilities to help detect and identify performance problems in the online part of the application. In this chapter, I discuss some aspects of these utilities.

This chapter does not seek to replace PeopleSoft's documentation. Instead, you are advised to read this chapter in conjunction with PeopleBooks.

Query Metrics in PeopleTools 8.4

In PeopleTools 8.4, PeopleSoft introduced two new methods of collecting query execution times, query statistics and query logging.

Query Statistics

Whenever a query is executed by PeopleTools,1 the new average execution time, fetch time, and number of rows for that query, across all executions, is either inserted ...

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.