Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

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?

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

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 11 Sep 2001 04:15:08 -0700
Message-ID: <a20d28ee.0109110315.53aca217@posting.google.com>


"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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US