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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
