Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> SOLVED: Need help debugging ORA-00060: DEADLOCK
Thanks -
We finally determined that the problem happened because update statements were updating (though not changing the value of) the PK on parent tables - FK constraints/ RI enforcement somehow resulted in a table lock - problem was solved by adding indexes on child table FK's.
Phew!
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Wed Oct 20 1999 - 09:59:04 CDT