Re: What row and table are locked

In message <mmoritzE79Cxo.67L_at_netcom.com>

        mmoritz_at_netcom.com (Mike Moritz) writes:

> 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?

look in v$session.lockwait or better still use monitor
> 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 Sun Apr 13 1997 - 00:00:00 CDT