Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Tuning for rollbacks?
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 DBAReceived on Thu Sep 15 2005 - 08:02:42 CDT
![]() |
![]() |