Performance issues after upgrade PERS_SRCH_GBL, PERS_SRCH_QRY & EMPLMT_SRCH_GBL On Oracle 12+ DB
(Doc ID 2530787.1)
Last updated on JULY 22, 2020
Applies to:PeopleSoft Enterprise HCM Human Resources - Version 9.2 to 9.2 [Release 9]
Generic (Platform Independent)
After upgrading from Oracle 18.104.22.168 to 22.214.171.124.0 we are seeing some performance issues with some of the security views. I have a question on Bug 28291640 : PERFORMANCE ISSUES WITH PERS_SRCH_GBL, PERS_SRCH_QRY & EMPLMT_SRCH_GBL It states....
The view EMPLMT_SRCH_QRY it has a default SQL (making use of exists) and an optimized version for Oracle (purely joins). The 3 views above don't have the Oracle optimized versions.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document