Re: Delete without Rollback ?

You can if you use discrete transactions,

but (there's always a but!),

only use discrete for very small very short transactions (ie, singular row update/insert/delete), that post and commit virtually at the same time.

The discrete transaction does not use the rollback segment; instead of writing directly to disk, the changes are written to a temporary space. On commit the changes are written to disk; hence maintaining consistency. This can help to reduce your rollback segment size (and number of) and if you run long running queries at the same time, reduce the number of ORA-15555 (?) snapshot too old errors.

The best use of discrete transactions are concurrent OLTP systems.

Hope this helps,

Andy Tasker
DBA John Finn wrote in message <35C85724.CCE4EA38_at_a.com>...
>Does anyone know how to Delete without Rollback transaction overhead?
>
>"DELETE FROM TABLE1 WHERE ..."
>
>and no transaction overhead, rollback, commit ...
>
>
>thanks
>jfinn
Received on Wed Aug 05 1998 - 13:16:32 CDT