Technology Stack - EBS (MOSC)

MOSC Banner

SQL Details: 7qs7fx89194u, 2mwvn9xwq1tz3 causing more coursor pin s wait x

edited May 16, 2014 6:49AM in Technology Stack - EBS (MOSC) 4 commentsAnswered

Hi All

As per our observation we have seen this sql id is causing the concurrency on our database (10.2.0.4) with Ebs (12.0.6), we have analyzed that may be it is due to coursor pin s wait x

Here is the queries 

7qs7fx89194u

SELECT PROFILE_OPTION_VALUE
FROM FND_PROFILE_OPTION_VALUES
WHERE PROFILE_OPTION_ID = :B4 AND APPLICATION_ID = :B3 AND LEVEL_ID = :B2 AND LEVEL_VALUE = :B1 AND PROFILE_OPTION_VALUE IS NOT NULL

2mwvn9xwq1tz3

select (RUNNING_PROCESSES-MAX_PROCESSES) ,MAX_PROCESSES

             ,NVL(SLEEP_SECONDS,0) ,DIAGNOSTIC_LEVEL into :b0,:b1,:b2,:b3:b4

             from FND_CONCURRENT_QUEUES where ((APPLICATION_ID=:b5 and

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center