PSQUERY Performance Degradation in 19c with Views POSTN_SRCH_QRY and EMPLMT_SRCH_QRY
(Doc ID 2804537.1)
Last updated on JANUARY 26, 2024
Applies to:
PeopleSoft Enterprise HCM Human Resources - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
PSQUERY Performance Degradation in 19c upto DBRU 19.5 with Views POSTN_SRCH_QRY and EMPLMT_SRCH_QRY
1) Run the PSQUERY delivered or Customized with views POSTN_SRCH_QRY and EMPLMT_SRCH_QRY
2) Severe Degradation of the query is seen in few cases where the views are joined with many tables or used in a Subquery.
3) Query plans may differ from 12c or lower version, visible change in join order and join method
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 |
References |