Re: Row Locking

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.