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

For high OLTP volume with large number of concurrent users, wouldn't it be better to divide that 2GB into many, many rollback segments? Your configuration of a few, large segments looks like an OLAP envirnomnent with few users and long running SQL Selects, or for cases where you need to perform batch inserts or updates before commiting.

What are the RBS initial/next extent sizes, and what are the settings for minimum extents and optimal extents (8.1.5 option).?

What is the size of a typical update transaction?

What is the poor programming?

> 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.
Received on Wed Sep 12 2001 - 01:01:38 CDT