Re: Blocking_session is blocker or blocked

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