Re: Is it better to drop a rollback segment and recreate it instead of add additional rollback segment?

What is INITIAL and NEXT extend in your rollback segment? I recommended that you add more rollback segments.

"K.P, Ng" wrote:

> I alway take the rollback segment offline before I drop it. However, I don't
> think this task is the best way to solve the problem. Is there any scripts
> to capture the usage of each rollback segment. I do have one but it just
> show the usage at one time only.
>
> Rgds,
> Pang
>
> "Reid Lai" <reidlai_at_netvigator.com> wrote in message
> news:3B9DC77E.C117BBB8_at_netvigator.com...
> > Make sure you don't open your database to user. Dropping rollback segment
> > is not a problem except some users are performing transaction.
> >
> > "K.P, Ng" wrote:
> >
> > > Ver: 8.1.5.0 Enterprise
> > > O.S: AIX 4.3.3.0
> > > Application: On-line security and trading system.
> > > Transactions: High
> > > Tablespace for Production: 32GB
> > > No. of rollback segment: 4 (R01-R04)
> > > Size of tablespace for rollback segment: 2GB
> > >
> > > Q: Due to poor programming, the rollback segment growth quickly for a
> > > particular rollback segment. e.g R01. Is it better to drop this rollback
> > > segment and recreate it, or just add additional rollback segment.
> > >
> > > Rgds,
> >
Received on Fri Sep 14 2001 - 11:45:55 CDT