Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

DB01 deadlock tables

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

Former Member
Former Member replied

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question