Re: Deadlocks
- From: Guillermo Alan Bort <cicciuxdba@xxxxxxxxx>
- To: afatkulin@xxxxxxxxx
- Date: Tue, 29 Sep 2009 17:03:31 -0300
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
Other related posts: