You can bring the rollback segments offline, but like the expert said, u
can't tell Oracle not to use it. You can bring all the online segments
offline(except SYSTEM rollback segment - that's a no can do) but ur delete
statement will error out. Oracle searches for any available online rollback
segment in any tablespace for its use. If its doesn't find one - error (
this does not include the SYSTEM rollback seg).
Ur solution would be to create a pretty large rollback segment & set the
transaction(eg. delete) to use that particular rollback segment OR do the
delete using a procedure with a commit after every - say 1000 or more
deletes( depending on the size of ur rollback segment).
Hope this helps u.
"Artur Undebarrena" <aundebarrena_at_ictnet.es> wrote in message
news:3C5D43ED.C956D19E_at_ictnet.es...
> Then, Is it impossible to deactivate the rollback function?
>
> Thanks.
>
>
> 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.
> > >
> > >
> > >
>
Received on Wed Feb 13 2002 - 13:46:43 CST
