Re: How to remove Deadlocks on Oracle DB 7.3.3

From: wv <wvollenw_at_bellsouth.net>
Date: 2000/04/22
Message-ID: <39024ED5.F6689A98@bellsouth.net>#1/1

I am assuming you are talking about a row level deadlock on a table....If so Oracle should detect and clean the deadlock. If you can't wait for Oracle to cleanup the deadlock you can always kill one or both of the sessions that have the data locked.

Srimal wrote:

> Hi,
>
> I am running a Database on Solaris Server.
> Deadlock has occured to a one Row. I want that to recover immediately
> without shutdown the Database and Restart it.
> Can I do that and help me on that.
>
> Thanks in advance.
>
> Srimal
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sat Apr 22 2000 - 00:00:00 CDT