Home -> Mailing Lists -> Oracle-L -> Blocking_session is blocker or blocked

Blocking_session is blocker or blocked

From: Eriovaldo Andrietta <ecandrietta_at_gmail.com>
Date: Thu, 1 Aug 2019 12:06:11 -0300
Message-ID: <CAJdDhaOCkjF5gRjLmsM9vGp+q9f3N+T3hsxAOWy59OCp54E_dA_at_mail.gmail.com> 





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


Received on Thu Aug 01 2019 - 17:06:11 CEST












Original text of this message