Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Delete without Rollback ?
I too am looking at storing 10000 numbers/ second aquired from process
instruments and
do not need any Rollback. Are there any benchmarks avaible on Oracle for
similar
work.
thanks
butun
EXE wrote:
> > You can't do that. This work style is the base to Oracle Engine.
> > You have only one exception, the "truncate" statement. With this command
> > you can
> > delete all rows from a table, but you can't choose them.
>
> I agree with this advice but would like to post a thought here that perhaps
> will be picked up by someone at Oracle. That thought is that there should be
> a way to intentionally turn off the use of rollback segments.
>
> While this is wholly inappropriate in an OLTP environment when working with
> a very large data-warehouse or data-mart where the object is to update a
> huge number of row on an all or nothing basis it is just a complete waste of
> resources to be building up a rollback segment with information that will
> never be rolled back. If the process fails the standard course of action is
> to just reload from scratch and try again.
>
> Regards,
>
> Daniel A. Morgan
Received on Thu Aug 13 1998 - 11:05:55 CDT