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

Home -> Community -> Usenet -> c.d.o.server -> Re: Is it better to drop a rollback segment and recreate it instead of add additional rollback segment?

From: Reid Lai <reidlai_at_netvigator.com>
Date: Tue, 11 Sep 2001 16:12:46 +0800
Message-ID: <3B9DC77E.C117BBB8@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 - 03:12:46 CDT