Re: Deriving Intial & next parameters

The way I like to do it it so size your rollback tablespace to be roughly the size the largest tablespace. If possible (and space permits) add to that the corresponding index tablespace as well. I realize that this is quite large, however, this will ensure that you will never outgrow your rollback tablespace. Now, take that sum total of the tablespace and mulitply by .75 (75%). Take the result and divide into equal amounts - I use the divisor of 250. This will be the initial and next extent of ALL of your rollback segments. What this will ensure is that any one rollback segment will have the capability of extending throughout 75% of the entire tablespace. The reason I don't use it all is in the unlikely event that two very intensive update/delete processes are going on at the same time - this will ensure that both have the ability to expand without blowing the tablespace.

-Sheilah Scheurich
DBA
My email is wrong - remove the words "want no spam at all" to send me anything.

nmk_1970_at_hotmail.com wrote:

> Hi netters,
>
> Is there any predefined rule to derive the above parameters
> while creating the rollback segment while creating a new database.
>
> TIA
>
> /muralikrishna
>
> -------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet
Received on Tue Jan 13 1998 - 00:00:00 CST