My Oracle Support Banner

After Database Upgrade to Oracle Database 19c, Performance Issues with Peoplesoft Complex Queries (Doc ID 2744611.1)

Last updated on FEBRUARY 01, 2021

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

After Database Upgrade to Oracle 19c, performance issues with Peoplesoft Complex queries that use security views, PS_EMPLMT_SRCH_QRY and PS_PERALL_SEC_QRY. 
For example, some custom queries are taking very long time to run and other keep running, endlessly. 


Steps to Replicate Issue:

1. Create custom Query using PS_JOB that automatically joins PS_EMPLMT_SRCH
2. Upgrade Peopletools 8.58.04 and Oracle Database 19c
3. Run the custom Query again, no longer runs with no errors.

Changes

 

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
Changes
Cause
Solution
References


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