Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Rollback question
In article <3C5D43ED.C956D19E_at_ictnet.es>, Artur says...
>
>Then, Is it impossible to deactivate the rollback function?
>
>Thanks.
>
with the exception of a very few commands -- yes. You might believe you don't "need to rollback" but you do.
Suppose you were in the middle of a DELETE and the system failed. If we didn't have rollback for it -- you would have a corrupt database, you lose
there are some commands that will bypass undo and redo generate, like a direct path insert (insert /*+ append */ into t select ...), create table as select nologging, create index nologging, but in general, all insert/update/delete activity will generate undo.
>
>En/Na "Jaap W. van Dijk" ha escrit:
>
>> You can't.
>>
>> Rollback is not only used for rolling back but also for guaranteeing
>> that a query of another user sees the database as it is at the start
>> of the query: of all blocks that change during the runtime of the
>> query the original data is retrieved from the rollback the updating
>> processes have generated.
>>
>> Jaap.
>>
>> On Sun, 03 Feb 2002 13:16:05 +0100, Artur Undebarrena
>> <aundebarrena_at_ictnet.es> wrote:
>>
>> >Hello.
>> >
>> >I need to tell to Oracle database that do not use the rollback SQL
>> >command to accelerate the delete command. I use databases in development
>> >process and I don't need to rollback the inserts, updates and deletes. I
>> >want to accelerate my sql queries and I think if I deactivate the
>> >rollback command I'll win in speed.
>> >
>> >
>> >Thank you very much.
>> >
>> >
>> >
>
-- Thomas Kyte (tkyte@us.oracle.com) http://asktom.oracle.com/ Expert one on one Oracle, programming techniques and solutions for Oracle. http://www.amazon.com/exec/obidos/ASIN/1861004826/ Opinions are mine and do not necessarily reflect those of Oracle CorpReceived on Sun Feb 03 2002 - 09:49:18 CST
![]() |
![]() |