Performance Issue Of PS_PERALL_SEC_QRY And PS_EMPLMT_SRCH_QRY (Doc ID 2206115.1)

Last updated on NOVEMBER 21, 2016

Applies to:

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

Symptoms

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."

Cause

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