Home » RDBMS Server » Server Administration » deadlocks
deadlocks [message #130468] Sun, 31 July 2005 01:17 Go to next message
sarfraz_attari
Messages: 123
Registered: July 2005
Senior Member
can anyone tell me how to find the deadlock if there is any
and how to remove deadlocks

Report message to a moderator

Re: deadlocks [message #130481 is a reply to message #130468] Sun, 31 July 2005 05:42 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member


Whenever there is a deadlock a trace file is created in UDUMP.

Read this link for details.


http://www.stormloader.com/yonghuang/computer/deadlocks.txt


regards,

tarun

Report message to a moderator

Re: deadlocks [message #130554 is a reply to message #130481] Mon, 01 August 2005 01:24 Go to previous messageGo to next message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
Also, you will get an entry in alert log file statin Deadlock Detected.

Regds
Girish

Report message to a moderator

Re: deadlocks [message #130562 is a reply to message #130554] Mon, 01 August 2005 02:02 Go to previous messageGo to next message
sarfraz_attari
Messages: 123
Registered: July 2005
Senior Member
I want to know how to remove deadlock if it exists

Report message to a moderator

Re: deadlocks [message #130846 is a reply to message #130562] Tue, 02 August 2005 19:08 Go to previous message
mrmarath
Messages: 23
Registered: July 2005
Junior Member
As you know a deadlock can arise when two or more users wait for data locked by each other.The oracle server automatically detects and resolves deadlocks by rolling back the statement that detected the deadlock.
For eg:Consider two transactions, if transaction 1 detects the deadlock, the oracle server rolls back that statement and returns the message.Although the statement that caused the deadlock is rolled back, the transaction is not, and you receive an ORA-00060 error.Your next action should be to rollback the remainder of the transaction.
Regards
Rajesh

Report message to a moderator

Previous Topic: OSD-04002: unable to open file
Next Topic: Rollback segment Problem
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jan 10 08:53:20 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.