Re: Error of deadlock detected while trying to lock object (ora-04020)

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Fri, 26 Mar 2004 00:29:40 GMT
Message-ID: <UPK8c.86388$KB.26101@twister.nyroc.rr.com>

"cschang" <cschang_at_maxinter.net> wrote in message news:40634956.1060509_at_maxinter.net...
> Thanks Anurag. Certainly I have not tried the first point which I had
> no knowledge on it. I tried the utlrp but all the invalid were still
> there. Third, I might go deeper in metalink. Of course, i can wipe out
> the whole thing, it is time for 9i anyway, but I really like the
> opportunity to learn why so I can design my codes more carefully. Do
> you think the DBMS_job will cause this because there is dbms_job run
> around the time when the error occured ( I need to double check).
>
> Chisoon
>

--snip--

dbms_job is just running *some* code. It might or might not be the cause. You need to set the event as noted in my earlier post to get a better idea about what might be the cause.

Anurag Received on Thu Mar 25 2004 - 18:29:40 CST