Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Ora 04020 - deadlock detected while trying to lock object

Ora 04020 - deadlock detected while trying to lock object

From: Alan Formstone <aformstone_at_us.lhsgroup.com>
Date: Mon, 25 Oct 1999 15:50:37 -0400
Message-ID: <3814b4b8@news.lhsgroup.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US