Re: Rollback question

From: Jaap W. van Dijk <j.w.vandijk_at_hetnet.nl>
Date: Sun, 03 Feb 2002 13:02:30 GMT
Message-ID: <3c5d33e1.4358921@news.jaapwvandijk.myweb.nl>

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.
>
>
>
Received on Sun Feb 03 2002 - 07:02:30 CST