Re: RE: TX locks

From: <solbeach_at_cox.net>
Date: Thu, 27 May 2004 11:46:54 -0400
Message-Id: <20040527154656.BHOC24307.fed1rmmtao10.cox.net@smtp.west.cox.net>

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
/

---

displays the SID of both the "holder" & the "waiter" session

---

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 Thu May 27 2004 - 10:43:50 CDT