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,

If it's growing too much, then it's a good idea to recreate at a size that hovers around the current high water mark. Remember to create plenty of extents per segment and enough segments for expected level of transactions. Also, the extent size of the segment may require some attention depending on the volume per transaction. Check out the dynamic v$ views of rollback segment performance and read the section of the manual on deriving how many segments to create, size guidelines etc. Received on Tue Sep 11 2001 - 12:01:31 CEST