on 08-12-2011 7:45 PM
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
Hello sume,
you can the DB01 lock table info from menu --> application help --> technical help.
Hope this helps
Regards
venkata
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
V$LOCK
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.