Re: Lock contention

From: Christian Trassens <ctrassens_at_yahoo.com>
Date: Mon, 30 Jul 2001 03:28:03 -0700
Message-ID: <F001.00358B36.20010730030020@fatcity.com>

select p1,p2,p3,sid from V$session_wait where event='enqueue';

select * from v$lock where block=1; <---- the blocker

select * from v$lock where request>0 <----the waiter

And after running @?/rdbms/admin/catblock.sql

select * from sys.dba_waiters

• Viraj Luthra <viraj999_at_lycos.com> wrote:
  > Hello,
  >
  > How do I find out the sessions in the systems that
  > are waiting for locks and corresponding locks. In
  > other words, how, an sql script will really help,
  > will provide me if a lock contention is going on?
  >
  > rgds,
  >
  > raja
  >
  >
  > Get 250 color business cards for FREE!
  > http://businesscards.lycos.com/vp/fastpath/
  > --
  > Please see the official ORACLE-L FAQ:
  > http://www.orafaq.com
  > --
  > Author: Viraj Luthra
  > INET: viraj999_at_lycos.com
  >
  > Fat City Network Services -- (858) 538-5051 FAX:
  > (858) 538-5051
  > San Diego, California -- Public Internet
  > access / Mailing Lists
  >
  

  ---

  
  > To REMOVE yourself from this mailing list, send an
  > E-Mail message
  > to: ListGuru_at_fatcity.com (note EXACT spelling of
  > 'ListGuru') and in
  > the message BODY, include a line containing: UNSUB
  > ORACLE-L
  > (or the name of mailing list you want to be removed
  > from). You may
  > also send the HELP command for other information
  > (like subscribing).
  

  ---

Eng. Christian Trassens
Senior DBA
Systems Engineer
ctrassens_at_yahoo.com
ctrassens_at_hotmail.com
Phone : 541149816062

---

Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Christian Trassens
  INET: ctrassens_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Mon Jul 30 2001 - 05:28:03 CDT