OraFAQ Forum: Server Administration » To identify deadlocks

Home » RDBMS Server » Server Administration » To identify deadlocks

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

To identify deadlocks [message #153947]

Thu, 05 January 2006 01:29

*Jess*
Messages: 48
Registered: December 2005
Location: Penang, Malaysia

Member

Hi all admins,

I would like to know where to find dead locks occur in my system. From alert.log? What is the exact message error will occur in alert log if dead locks occur?

Another question, if there is an dead lock, where to check it is belongs to which table and which user accessing it?

Thanks in advance!

Report message to a moderator

Re: To identify deadlocks [message #153950 is a reply to message #153947]

Thu, 05 January 2006 01:34

Frank Naude
Messages: 4596
Registered: April 1998

Senior Member

This should answer most of your questions - http://www.orafaq.com/faq/what_is_a_deadlock_and_how_does_one_fix_deadlock_errors

Report message to a moderator

Re: To identify deadlocks [message #153953 is a reply to message #153947]

Thu, 05 January 2006 01:41

*Jess*
Messages: 48
Registered: December 2005
Location: Penang, Malaysia

Member

Ok, thanks a lot. It is very much appreciated.

Dead locks will resolve automatically by Oracle right? Admins do not need to kill the user sessions which are holding the table.

Correct me if i'm wrong. Thanks!

Report message to a moderator

Re: To identify deadlocks [message #153956 is a reply to message #153953]

Thu, 05 January 2006 01:51

Frank Naude
Messages: 4596
Registered: April 1998

Senior Member

Right. Oracle will detect deadlocks automatically and rollback some transactions to prevent them from becoming deadly embraced.

Report message to a moderator

Previous Topic:	How to create schema?
Next Topic:	service - started and stopped

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 27 18:24:59 CDT 2026