Fluid Candidate Gateway On PUM22 Is Hung While Connecting - Slow Response Time While Performing Full Table Scan On PS_HRS_APPLICANT
Last updated on OCTOBER 23, 2017
Applies to:PeopleSoft Enterprise HCM Candidate Gateway - Version 9.2 and later
Information in this document applies to any platform.
On : 9.2 version, Performance
Response time connecting to TAM Candidate Gateway is seriously degrading after applying PUM22
When executing component HRS_CG_SEARCH_FL and selecting a large number (e.g. 3+ million rows) from PS_HRS_APPLICANT, Application Servers have become non-responsive.
PSAPPSRV servers are seen to be queueing.
Average response time in Candidate Gateway should be in the 1-3 second timeframe as seen in the pre-PUM22 environments.
The issue can be reproduced at will with the following steps:
1. login to the Candidate Gateway
2. observe that connections are spinning and the environment appears hung
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