E-SES: CPU Utilization Increased after Upgrading to PeopleTools 8.55 when processing SES Facets
Last updated on FEBRUARY 14, 2017
Applies to:PeopleSoft Enterprise PT PeopleTools - Version 8.55 and later
Information in this document applies to any platform.
DB2 CPU utilization spiked after upgrading from PeopleTools 8.54 to 8.55.
Analysis of resource consuming queries showed that the following SQL was at fault:
This query is used in the two app packages involved in producing facets.
Customer has provided a recommended index and query rewrite which they have implemented as a workaround.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms