Re: Deadlocks

  • From: Alex Fatkulin <afatkulin@xxxxxxxxx>
  • To: Guillermo Alan Bort <cicciuxdba@xxxxxxxxx>
  • Date: Tue, 29 Sep 2009 16:12:40 -0400

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@xxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l


Other related posts: