Home » RDBMS Server » Server Administration » ORA-04020 deadlock detected
icon9.gif  ORA-04020 deadlock detected [message #116215] Mon, 18 April 2005 10:31 Go to next message
ljj123
Messages: 3
Registered: March 2005
Location: tunisie
Junior Member
my database version is 8.1.7
when executing a procedure, this error appear:(ORA-04020 deadlock detected while trying to lock object stringstringstringstringstring)
thanks for your help

Report message to a moderator

Re: ORA-04020 deadlock detected [message #116218 is a reply to message #116215] Mon, 18 April 2005 10:41 Go to previous message
Frank Naude
Messages: 4587
Registered: April 1998
Senior Member
Every deadlock should dump a trace file in your database's UDUMP directory. View/print these trace files for more details regarding this error.

Also read this FAQ - http://www.orafaq.com/faq/RDBMS_Server/Internals/faq503.htm

Best regards.

Frank

Report message to a moderator

Previous Topic: a question about FGA commit
Next Topic: ora -01691 Unable to extend LOB...
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jan 25 03:48:56 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.