What row and table are locked

From: Mike Moritz <mmoritz_at_netcom.com>
Date: 1997/03/18
Message-ID: <mmoritzE79Cxo.67L@netcom.com>#1/1

I am running Oracle Server 7.1.4.1.0

Can someone help me determine what rows of what tables users are locking? If I am way off base here, does anyone have some scripts that will provide the desired info.

I've figured out how to determine which users have locks but am not able to determine what table and row they are locking.

I think the solution lies in the ability to decode the *ADDR fields of v$_lock. Does one of the *ADDR point to a ROWID? Am I close?

Can anyone tell me what these fields point to and how to decode them?

SQL> describe v$_lock;
 Name Null? Type

• -------- ---- LADDR RAW(4) KADDR RAW(4) SADDR RAW(4) RADDR RAW(4) LMODE NUMBER REQUEST NUMBER

Thanks

-- 
    __  __  _  _
   |  \/  |(_)| |__ ___                                      __o
   | |\/| || || / // -_)      Mike Moritz                  _ \<._
   |_|  |_||_||_\_\\___|      mmoritz_at_netcom.com      ____(_)/ (_)____

Received on Tue Mar 18 1997 - 00:00:00 CST