Re: Row Locking on Oracle 8

From: Jeremiah Wilton <jeremiah_at_wolfenet.com>
Date: Fri, 17 Sep 1999 12:06:08 -0700
Message-ID: <37E29120.48E97559@wolfenet.com>

Karen Abgarian wrote:

> You cannot get the information about the locked rows from v$ tables, because
> it's not there. The locking information is stored in the database along with
> rows.

If someone is really being blocked, the row number is in v$session(row_wait_row#) for the session being blocked. The blocker is available from v$lock by joining the waiter's v$session(taddr) with v$transaction(addr). So if there is a real blocking situation, you can get all the information mentioned in the original message. You can make Oracle8 rowids out of this data with the dbms_rowid built in package. --
Jeremiah

>
> Juan Carlos Alonso Lafuente wrote:
>
> > The question is that we would like to know who is blocking one row in a
> > table and which particular row (its rowid).
> >
> > Using v$session and v$lock we get to know who is blocking a particular
> > object (a table) but we do not know the row being blocked.
Received on Fri Sep 17 1999 - 14:06:08 CDT