Posted on 2004-10-12
once again we've got one of these Oracle riddles...
We have set up a new database with the same data structures we are using for years now, but this time we got problems. There are, of course, differences in the databases: Oracle version, operating system, backup concept etc. vary from instance to instance. However, we do not understand why we have this type of problem.
There is one table with about 1000 - 10000 data sets in it. There are a lot of contraints and indexes on the table. There are also triggers which control the data inserted or updated.
What we are trying to do is update a column which is not involved in the constraints. We get an error ORA-000060 (deadlock while waiting for ressource).
I would be happy to provide any more information but there is so much I could tell you about the table that I don't know where to start :-).
What are possible reasons for the deadlock, and how do we get rid of that?