Re: Blocking_session is blocker or blocked

From: Powell, Mark <>
Date: Thu, 8 Aug 2019 16:47:48 +0000
Message-ID: <>

Ecandrietta, being that the OP's posted query uses V$SESSION and that 'VALID' is not one of the five valid values of the STATUS column what column value are you referring to?

Mark Powell
Database Administration
(313) 592-5148

From: <> on behalf of Matt Adams <> Sent: Thursday, August 1, 2019 1:07:52 PM To: <>; ORACLE-L <> Subject: RE: Blocking_session is blocker or blocked

You may want to add the clause

and blocking_session_status = 'VALID'

I’ve seen cases where blocking_session is not null, but the blocking_session_status != ‘VALID’. I believe that both checks are needed to avoid giving false positives.

From: <> On Behalf Of Eriovaldo Andrietta Sent: Thursday, August 01, 2019 11:06 AM To: ORACLE-L <> Subject: Blocking_session is blocker or blocked

CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe.


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;



Privacy Statement: The information contained in this transmission, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure, or distribution is prohibited by Federal law. If you are not the intended recipient of this message, you are notified that you may not disclose, print, copy, or disseminate this information. If you have received this transmission in error, please reply to the sender and delete or destroy the message. Unauthorized interception of this transmission may be a violation of criminal law.

DXC Technology Company - Headquarters: 1775 Tysons Boulevard, Tysons, Virginia 22102, USA. DXC Technology Company -- This message is transmitted to you by or on behalf of DXC Technology Company or one of its affiliates. It is intended exclusively for the addressee. The substance of this message, along with any attachments, may contain proprietary, confidential or privileged information or information that is otherwise legally exempt from disclosure. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient of this message, you are not authorized to read, print, retain, copy or disseminate any part of this message. If you have received this message in error, please destroy and delete all copies and notify the sender by return e-mail. Regardless of content, this e-mail shall not operate to bind DXC Technology Company or any of its affiliates to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. --.

Received on Thu Aug 08 2019 - 18:47:48 CEST

Original text of this message