Re: questions regarding locks

On 30 Apr 1997 21:23:13 GMT, lesliet_at_u.washington.edu (L. Tseng) wrote:

>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

Look at the table called DBA_DML_LOCKS. This will give you much of the information that you seek. It is easier to see this information in this table than in the v$tables.

sheilah scheurich
scheuric_at_sprynet.com
DBA Received on Thu May 01 1997 - 00:00:00 CDT