Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
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?
"K.P, Ng" <kpng_at_sywg.com.hk> wrote in message news:<9nkbh6$5tc1_at_imsp212.netvigator.com>...
> 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,
alter rollback segment <segment_name> shrink to ... M
Hth,
Sybrand Bakker, Senior Oracle DBA Received on Tue Sep 11 2001 - 06:15:08 CDT