Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Tuning for rollbacks?

Re: Tuning for rollbacks?

From: <sybrandb_at_yahoo.com>
Date: 15 Sep 2005 06:02:42 -0700
Message-ID: <1126789362.346980.311650@g44g2000cwa.googlegroups.com>


In Oracle, commit means: write a commit marker. Rollback means: read the associated rollback segments and update the corresponding database blocks.
This should explain why a rollback is 'slower' and why your method is very strange.
And no: you can't 'tune' rollback, apart from tuning your rollback segments, as rollback ought to be very rare, and not by design.

-- 
Sybrand Bakker
Senior Oracle DBA
Received on Thu Sep 15 2005 - 08:02:42 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US