Re: Deadlocks

From: Guillermo Alan Bort <>
Date: Tue, 29 Sep 2009 17:03:31 -0300
Message-ID: <>

If I recall correctly, a deadlock gives an ora-60 error in the alert log and kills one of the two sessions (which one has always been a mistery to me, the doc says it's the one that initiates the deadlock... but since deadlock is essentialy a circular block, this makes little sense). Now, when Oracle kills a session, the ENTIRE transaction is rolled back.

Alan Bort
Oracle Certified Professional

Received on Tue Sep 29 2009 - 15:03:31 CDT

Original text of this message