DB01 deadlock tables
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.
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