Re: Blocking_session is blocker or blocked

Mark,
Thanks for your attention and answer.
Regards
Eriovaldo

Em qui, 1 de ago de 2019 às 13:00, Mark J. Bobak <mark_at_bobak.net> escreveu:

> blocking_session is the blocker, not the blockee. In other words, it's
> the session holding the lock and doing the blocking. SID is the session
> being blocked.
>
> -Mark
>
> On Thu, Aug 1, 2019 at 11:07 AM Eriovaldo Andrietta <ecandrietta_at_gmail.com>
> wrote:
>
>> Hello,
>>
>> In the sql below , the blocking_session is the BLOCKED or BLOCKER session
>> ?
>>
>> Select blocking_session, blocking_instance,wait_class, sid, serial#,
>> inst_id,
>> seconds_in_wait, program, module, s.LOGON_TIME
>> From gv$session s
>> where blocking_session is not NULL
>> order by blocking_session;
>>
>> Regards
>> Eriovaldo
>>
>

--
http://www.freelists.org/webpage/oracle-l