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.
In PeopleTools 8.4, PeopleSoft introduced two new methods of collecting query execution times, query statistics and query logging.
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 ...