Re: Deadlocks
From: Guillermo Alan Bort <cicciuxdba_at_gmail.com>
Date: Tue, 29 Sep 2009 17:03:31 -0300
Message-ID: <172762180909291303h30f50835yb234aaf3a50dee06_at_mail.gmail.com>
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.
Date: Tue, 29 Sep 2009 17:03:31 -0300
Message-ID: <172762180909291303h30f50835yb234aaf3a50dee06_at_mail.gmail.com>
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.
hth
Alan Bort
Oracle Certified Professional
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Sep 29 2009 - 15:03:31 CDT