How did you determine that the sessions are *waiting* and not on CPU (where
v$session incorrectly shows the previous wait event)... which exact query
... v$session ... or ASH?
--
Tanel Poder
https://blog.tanelpoder.com
On Fri, Dec 14, 2018 at 8:20 AM Kumar Madduri <ksmadduri@xxxxxxxxx> wrote:
Hello:
Oracle Applications 12.2 running against 12c database:
User submitted the same concurrent program (with different parameters) and
are running for long time . Noticed that all of the programs are on event
'cursor: pin s' and a set of sqls are the same (program 1 runs sql_id 1,
program 2 runs sql_id 1,
program 3 runs sql id 2,
program 4 runs sql id 3
and all of them are waiting on event "cursor: pin s" and that keeps
rotating between different programs (at time t1 program 1 uses sql_id 1 ,
at time t2 program 1 uses sql_id 2 but program 2 uses sql_ids 1 or 2 as
well. I think you see the pattern there)