My Oracle Support Banner

Performance Issue Of PS_PERALL_SEC_QRY And PS_EMPLMT_SRCH_QRY (Doc ID 2206115.1)

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.

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

To view full details, 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 a vibrant support community of peers and Oracle experts.