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

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 Tue Sep 11 2001 - 11:20:02 CEST