Our application hangs all the time. many time it gives error
ORA 0054 resource busy.
How can I find which session has lock which table via which SQL. and what type lock it is ? I try to check in V$lock, but I do not understand all the field in V$lock. Does any body knows how to detect lock ?
in v$Lock which is Idb1, idb2, lmode etc..
Where will I get information of data dictnery tables.
How can I resolve lock ?????