Re: Rollback question

My understanding is that, unlike the generation of redo information which can often be switched off, undo information is always generated. Or has this changed in Oracle 9i?

Jaap.

On 3 Feb 2002 07:49:18 -0800, Thomas Kyte <tkyte_at_us.oracle.com> wrote:

>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 Corp
>
Received on Sun Feb 03 2002 - 10:53:12 CST