Re: Blocking_session is blocker or blocked

  • From: "Mark J. Bobak" <mark@xxxxxxxxx>
  • To: ecandrietta@xxxxxxxxx
  • Date: Thu, 1 Aug 2019 12:00:46 -0400

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@xxxxxxxxx>
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

Other related posts: