Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: High "transaction rollbacks" value in v$sysstat
Thanks Lex and Phil for the pointers - very interesting reading indeed, unfortunately it doesn't seem to be related to my problem. I've had a short exchange with Tom Kyte and Jonathan Lewis over at asktom (http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:11504247549852) and, if I understand correclty, the "mini-rollback" that Oracle performs in order to implement "write consistency" does not show up in the 'transaction rollbacks' statistic. So, I've come to believe that the high 'transaction rollbacks' are the result of failed DML statements e.g. due to unique constraint violations.
Now to try and figure out exactly what statements are failing and why . . .
>>Re: High "transaction rollbacks" value in v$sysstat
>>From: Phil Jones <phillipjones_at_xxxxxxxxx>
>>To: lex.de.haan_at_xxxxxxxxxxxxxx
>>Date: Sat, 10 Sep 2005 12:55:57 +0000
>>See his recent blog entries:
On 10/09/05, Lex de Haan <lex.de.haan_at_xxxxxxxxxxxxxx> wrote: > yep -- the famous (but less well known) Oracle feature "write consistency"
Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Sep 12 2005 - 18:13:03 CDT
![]() |
![]() |