RE: Blocking_session is blocker or blocked
Date: Thu, 1 Aug 2019 17:07:52 +0000
Message-ID: <DM6PR10MB4187CA5C584525754C2D799DA5DE0_at_DM6PR10MB4187.namprd10.prod.outlook.com>
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: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> On Behalf Of Eriovaldo Andrietta Sent: Thursday, August 01, 2019 11:06 AM To: ORACLE-L <oracle-l_at_freelists.org> 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. 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
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.
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Aug 01 2019 - 19:07:52 CEST