RE: enqueue wait objects?

From: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Fri, 20 Feb 2004 10:57:45 -0500
Message-ID: <4C9B6FDA0B06FE4DAF5918BBF0AD82CF03B452A7@bosmail00.bos.il.pqe>

It depends on the enqueue type. For example, in the case of a TM enqueue, id1 is the object_id. For a TX enqueue, id1 and id2 point to the rollback
Segment number, slot and wrap, where the transaction is defined.

Other enqueues have different meanings for id1 and id2. They may or may not identify a specific object.

-Mark

Mark J. Bobak
Oracle DBA
ProQuest Company
Ann Arbor, MI
"Imagination was given to man to compensate him for what he is not, and a sense of humor was provided to console him for what he is." --Horace Walpole

-----Original Message-----
From: solbeach_at_cox.net [mailto:solbeach_at_cox.net]=20 Sent: Friday, February 20, 2004 10:24 AM To: oracle-l_at_freelists.org
Subject: enqueue wait objects?

The SQL below allows me to identify users involved with enqueue waits.
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
SELECT DECODE(request,0,'Holder: ','Waiter: ')||sid sess,

         id1, id2, lmode, request, type
    FROM V$LOCK
   WHERE (id1, id2, type) IN

(SELECT id1, id2, type FROM V$LOCK WHERE request>0) ORDER BY id1, request
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
How do I identify which database objects are involved with an enqueue wait?

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Fri Feb 20 2004 - 09:57:45 CST