Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Row Locking

Re: Row Locking

From: <markp7832_at_my-deja.com>
Date: 2000/02/14
Message-ID: <889p97$36t$1@nnrp1.deja.com>#1/1

In article <l3Qp4.13003$VJ1.24649_at_newsfeeds.bigpond.com>,   "Graeme Farmer" <g_farmer_at_halas.com.au> wrote:
> Don't worry guys. I found heaps of info at Deja News.
> Looks like it can't be done.
>
> Graeme.
>

Yes, you can find which session is holding the lock that another session is waiting on; you just do not do it based on the rowid of the row that is locked. Look at the utllockt.sql script in $ORACLE_HOME/rdbms/admin to see how Oracle develops a tree of waiting sessions. You may also want to check out the catblock.sql script in the same directory which builds dictionary view dba_ddl_locks and dba_dml_locks to develop a query your prefer.

You should be able to find all the session waiting on a particular row by looking in v$session at the 4 row_wait* columns which make up a rowid. This will not show you the holder like you want, but the above will show you how to find that.

--
Mark D. Powell  -- The only advice that counts is the advice that
 you follow so follow your own advice --


Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Mon Feb 14 2000 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US