Performance Issue Of PS_PERALL_SEC_QRY And PS_EMPLMT_SRCH_QRY
Last updated on OCTOBER 25, 2017
Applies to:PeopleSoft Enterprise HCM Human Resources - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.
Users are receiving errors not only through PSQuery but also when using the SQL Developer Tool when users run below queries:
select * from PS_PERALL_SEC_QRY;
select * from PS_EMPLMT_SRCH_QRY;
We allotted 100GB space to PSTEMP tablespace and all space is occupied when we run above queries and throwing below error.
When we run above delivered queries it is taking too long time and times out or throws the Error below:
"Database error: ORA-01652: Unable to extend temp segment by 16 in tablespace PSTEMP."
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms