questions regarding locks

From: L. Tseng <lesliet_at_u.washington.edu>
Date: 1997/04/30
Message-ID: <5k8d81$rts@nntp6.u.washington.edu>#1/1

I have a table with one row in it. The table was locked by serveral processes with locked_mode 3 when I looked the v$locked_object table. My questions are:

How can I find out which process blocks which? Is there an order/sequence for the locks?

How can the same object/row be locked by many locks? This doesn't make sense to me in theory. Should all the other locks having a different lock mode instead of 3 ?

Thanks for the help.

Leslie Received on Wed Apr 30 1997 - 00:00:00 CDT