My Oracle Support Banner

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)

Symptoms

After upgrading from Oracle 12.1.0.2 to 18.4.0.0.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....

PERS_SRCH_GBL
PERS_SRCH_QRY
EMPLMT_SRCH_GBL

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.

Cause

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
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.