Re: Wait Event “cursor: pin s” in Oracle Applications
Date: Fri, 14 Dec 2018 17:43:00 -0500
Message-ID: <CAMHX9JK4Z+Xfoa6mt9apft7q4BY+F43JbdEqp4X5HycBBg0DEw_at_mail.gmail.com>
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_at_gmail.com> 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)
>
>
>
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Dec 14 2018 - 23:43:00 CET