My Oracle Support Banner

Performance Issue Of PS_PERALL_SEC_QRY And PS_EMPLMT_SRCH_QRY (Doc ID 2206115.1)

Last updated on JUNE 22, 2022

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




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

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