Home » SQL & PL/SQL » SQL & PL/SQL » deadlock in table
deadlock in table [message #230671] Thu, 12 April 2007 10:04 Go to next message
pavuluri
Messages: 247
Registered: January 2007
Senior Member
how do u kill dead lock

assume that we are trying to update table at the same time.

how to reslove it?

thanks
srinivas
Re: deadlock in table [message #230673 is a reply to message #230671] Thu, 12 April 2007 10:08 Go to previous messageGo to next message
harshad.gohil
Messages: 157
Registered: April 2007
Location: USA
Senior Member
Hi Deadlock will handle by oracle itself, not required to do anything explicitly.

Regards,
Harsh
Re: deadlock in table [message #230677 is a reply to message #230673] Thu, 12 April 2007 10:19 Go to previous messageGo to next message
pavuluri
Messages: 247
Registered: January 2007
Senior Member
how to Release antoher user.

any option is there.

thanks
srinivas
Re: deadlock in table [message #230679 is a reply to message #230677] Thu, 12 April 2007 10:25 Go to previous messageGo to next message
Michel Cadot
Messages: 64131
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What do you mean:
Quote:
how to Release antoher user

Regards
Michel
Re: deadlock in table [message #230680 is a reply to message #230679] Thu, 12 April 2007 10:26 Go to previous messageGo to next message
pavuluri
Messages: 247
Registered: January 2007
Senior Member
iam sorry
thanks
srinivas
Re: deadlock in table [message #230687 is a reply to message #230680] Thu, 12 April 2007 10:38 Go to previous messageGo to next message
Michel Cadot
Messages: 64131
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Your posts or answers are often very cryptic.
You are sorry about what?

Regards
Michel
Re: deadlock in table [message #230766 is a reply to message #230671] Thu, 12 April 2007 14:23 Go to previous messageGo to next message
flyboy
Messages: 1832
Registered: November 2006
Senior Member
Quote:
how to Release antoher user

Do you mean how to unlock tables/rows locked by another user?
First, I would try to convince him to end his transaction.
If it would not help, I would DISCONNECT him (connected with necessary privileges, I would use user SYSTEM).
Re: deadlock in table [message #230787 is a reply to message #230766] Thu, 12 April 2007 17:37 Go to previous messageGo to next message
harshad.gohil
Messages: 157
Registered: April 2007
Location: USA
Senior Member
Perfect, we will ask them to disconnect otherwise we have to kill their session.

-Harsh
Re: deadlock in table [message #230795 is a reply to message #230671] Thu, 12 April 2007 20:51 Go to previous messageGo to next message
flyboy
Messages: 1832
Registered: November 2006
Senior Member
It is not necessary for him to disconnect. It would satisfy if he would end his current transaction by issuing COMMIT or ROLLBACK without SAVEPOINT.

Maybe it will be useful to read this article on AskTom to know how to detect locking sessions.

However, if you can not access the session, disconnecting it is the only choice to unlock objects locked by it, I am aware of.
Re: deadlock in table [message #230810 is a reply to message #230795] Thu, 12 April 2007 23:26 Go to previous messageGo to next message
Michel Cadot
Messages: 64131
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Guys, you are talking for nothing srinivas (pavuluri) didn't say what he wants!

Regards
Michel
Re: deadlock in table [message #230815 is a reply to message #230810] Fri, 13 April 2007 00:08 Go to previous messageGo to next message
pavuluri
Messages: 247
Registered: January 2007
Senior Member
please stop michel
Re: deadlock in table [message #230826 is a reply to message #230815] Fri, 13 April 2007 00:54 Go to previous messageGo to next message
Michel Cadot
Messages: 64131
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Stop what?
I still don't understand what you're saying.

Regards
Michel
Re: deadlock in table [message #230937 is a reply to message #230687] Fri, 13 April 2007 08:18 Go to previous messageGo to next message
joy_division
Messages: 4641
Registered: February 2005
Location: East Coast USA
Senior Member
Michel Cadot wrote on Thu, 12 April 2007 11:38
Your posts or answers are often very cryptic.
You are sorry about what?

Regards
Michel



I wholeheartedly agree with this. Grammatically incorrect sentences with nursery school spelling gibberish, not answering quetions asked and taking over the identity of the OP in many cases. It's like dealing with a stubborn illiterate schizophrenic.
Re: deadlock in table [message #231010 is a reply to message #230937] Fri, 13 April 2007 12:37 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
joy_division wrote on Fri, 13 April 2007 15:18
It's like dealing with a stubborn illiterate schizophrenic.

You know I actually even checked his IP against some other posters to see if he had more than one login?
Re: deadlock in table [message #231018 is a reply to message #231010] Fri, 13 April 2007 12:55 Go to previous message
joy_division
Messages: 4641
Registered: February 2005
Location: East Coast USA
Senior Member
Me too Smile
Previous Topic: deleteing duplicates using rownum
Next Topic: UPDATE/ INSERT in merge
Goto Forum:
  


Current Time: Wed Dec 07 12:32:52 CST 2016

Total time taken to generate the page: 0.11293 seconds