PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

PS Query runs very slow in PIA but faster in SQL Plus. Any pointers?

edited Apr 23, 2014 3:17PM in PeopleTools and Lifecycle Management - PSFT (MOSC) 9 commentsAnswered

We have a query that returns in 10 sec when run in SQLPLUS and TOAD but same query when run via PS Query (PIA) returns after 10 min.

Following things have been attempted so far without success -

1. Created more number of PSQRYSRV processes of app server. Currently, min 2, max 4

2. Bounced App server after clearing cache

3. Ran complete DB statistics

4. Tried scheduling the query

Our Env-

ELM 9.0   PT 8.51   The query is complex joining 6 tables and nested selects

Any pointers to solve this as soon as possible will help.

Thanks in advance.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

PSFT PeopleTools Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center