DB01 deadlock tables

[Former Member]

Hi,

Does anybody have name of the tables for dead lock display in DB01. I think it is a combination of multiple v$ tables.

It will be a great help. It is for Oracle 10.2.0.2.

Regards,

SC

[venkata_emandi · Accepted solution]

Hello sume,

you can the DB01 lock table info from menu --> application help --> technical help.

Hope this helps

Regards

venkata

[Former Member · Accepted solution]

I am aware of the V$LOCK table and other lock tables. They show locks.

The DB01 is for deadlock only and not normal locks.

Appliation help does not talk about the details at the table level.

Regards,

SC

[ashish_vikas · Accepted solution]

every lock wait in DB01 is not a deadlock, deadlock is just a special case where 2 or more session lock and wait for their locked objects..

In sessionA, update tb set col = 'x' where pk = 'aa'

In sessionB, update tb set col = 'x' where pk = 'bb'

In sessionA, update tb set col = 'x' where pk = 'bb'

In sessionB, update tb set col = 'x' where pk = 'aa'

If neither session commits, after the last statement, sessionA will throw error ORA-60 : Deadlock detected by Oracle.

to check deadlock, you should use ST04 > Detail analysis menu > Exclusive lock waits.

Level = -1: Deadlocks detected

Edited by: ashish vikas on Aug 20, 2011 3:03 PM

[Former Member · Accepted solution]

Thank you.

SC

[ashish_vikas]

V$LOCK