SQL Details: 7qs7fx89194u, 2mwvn9xwq1tz3 causing more coursor pin s wait x
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