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

Hi Reid,

The initial extend: 2048, next: 2080, max: 2147483645. So, there is plenty of space for rollback segments. I think I can do two things, one is to create an additional rollback, second, to delete and recreate the rollback segment every two weeks.

Pang

"Reid Lai" <reidlai_at_netvigator.com> wrote in message news:3BA23443.DD4F98B2_at_netvigator.com...
> 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 Mon Sep 17 2001 - 03:21:42 CEST