Re: Deadlocks

From: Alex Fatkulin <afatkulin_at_gmail.com>
Date: Tue, 29 Sep 2009 16:12:40 -0400
Message-ID: <49d668000909291312i325cd902y82d290e1dfcb2dfe_at_mail.gmail.com>

Oracle never kills the session as a result of ora-60. The session which received ora-60 can decide whether commit the work which was already done or repeat/modify/skip the statement.

On Tue, Sep 29, 2009 at 4:03 PM, Guillermo Alan Bort <cicciuxdba_at_gmail.com> wrote:
> If I recall correctly, a deadlock gives an ora-60 error in the alert log and
> kills one of the two sessions...

> hth
> Alan Bort
> Oracle Certified Professional
>

-- 
Alex Fatkulin,
http://afatkulin.blogspot.com
http://www.linkedin.com/in/alexfatkulin
--
http://www.freelists.org/webpage/oracle-l

Received on Tue Sep 29 2009 - 15:12:40 CDT