Re: ROLLBACK SEGMENTS: Some basic questions

and then set your maxextents to the maximum allowed by the block size, finally setting the initial and next extent sizes to (say) 5M to minimise the number of extents required, so you dont hit the maxextents limit again.

Lindsberger Franz <franz.lindsberger_at_siemens.at> wrote in article <32EF5E34.A13_at_siemens.at>...
> AMARENDRA B NETTEM wrote:
> >
> > Hi Arif,
> > The best solution is commit after every 100 transactions;
> >
> >
> > amar
> >
> > Atif Ahmad Khan <aak2_at_Ra.MsState.Edu> wrote in article
> > <aak2.853630433_at_Isis.MsState.Edu>...
> > >
> > > 1. Is there a way to have a transaction not use any rollback segment
 ?
> > >
> > > I am more concerned about performance and data loss is not really a
> > > concern.
> > >
> > > 2. I have a rather complicated PL/SQL script that works on a table
 that
> > > has 140,000 rows in it. The script is deleting rows based on a set
 of
 rules.
> > > The process after 30 minutes aborts and reports the following :
> > >
> > > BEGIN
> > > *
> > > ERROR at line 1:
> > > ORA-01562: failed to extend rollback segment number 1
> > > ORA-01628: max # extents (100) reached for rollback segment R01
> > >
> > > I thought I had taken care of all my rollback segment blues when I
 created
> > > the following rollback segment :
> > >
> > > create public rollback segment r01 tablespace RBS
> > > storage (initial 500K NEXT 500K OPTIMAL 10M MINEXTENTS 15 MAXEXTENTS
 100)
 ;
> > >
> > > I dropped all the other rollback segments intentionally to help me
 debug
> > > this problem. I am now thinking that maybe I should increase the
 maxextents
> > > to 200 or some such number and maybe add another rollback segment
 with
> > > identical settings. But I am not sure if that is going to solve my
 problem.
> > >
> > > Any ideas ?
> > >
> > > Atif Khan
> > > aak2_at_ra.msstate.edu
> > >
>
> 1st: say "SET TRANSACTION USE ROLLBACK SEGMENT
> an_extra_large_rollback_segment" immediately after beginning your
> mega-transaction.
>
> 2nd: make shure to have enough space in the datafile which contains your
> an_extra_large_rollback_segment
>
> greetings from AUSTRIA
>
  Received on Wed Jan 29 1997 - 00:00:00 CST