Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Ora 04020 - deadlock detected while trying to lock object
An application is trying to insert into a table and gets the above error.
Looking at the V$LOCK view shows the following:
SQL> select * from v$lock;
ADDR KADDR SID TY ID1 ID2 LMODE REQUEST CTIME BLOCK
20083414 20083424 2 MR 10 0 4 0 0 0 2008339C 200833AC 2 MR 1 0 4 0 0 0 20083360 20083370 2 MR 2 0 4 0 0 0 20083324 20083334 2 MR 3 0 4 0 0 0 200832E8 200832F8 2 MR 4 0 4 0 0 0 200832AC 200832BC 2 MR 5 0 4 0 0 0 20083270 20083280 2 MR 6 0 4 0 0 0 20083234 20083244 2 MR 7 0 4 0 0 0 200831F8 20083208 2 MR 8 0 4 0 0 0 200831BC 200831CC 2 MR 9 0 4 0 0 0 20083450 20083460 3 RT 1 0 6 0 0 0 200834C8 200834D8 5 TS 2 41943042 3 0 968 0
12 rows selected.
I restarted the database and the TS lock had disappeared. We reran the application and about a minute later this LOCK had reappeared.
The v$sysstats shows the following lock information :
SQL> select * from v$sysstat where name like '%lock%';
STATISTIC# NAME
CLASS VALUE
---------- ----------------------------------------------------------------
Any idea where else I could look to find out more about this problem. I've rescanned the server concepts manual with little joy, and have now run out of ideas.
The other V$ views concerning locks (like '%LOCK%') are empty.
Any help or pointers would be gratefully appreciated Received on Mon Oct 25 1999 - 14:50:37 CDT