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