Re: Rollback Segs

In article <3qvim4$13ba_at_newsgate.sps.mot.com>, r11324_at_email.sps.mot.com says:
>
>
>Hi,
>
>I have a question about Rollback Segs.
>I just inherited an oracle database.
>The tablespace for rollback was initially
>set at 200m. My users during an update
>process are experiencing max extents
>errors on the rbs tablespace. RBS
>is divided in the database into
>four segments:
>
>r01 12,300
>r02 84,400
>r03 59,680
>r04 47,320
>
>Does anybody have any suggestions for
>me to do without an impact on the
>production database?
>
>Thanks for any help.
>

If you have Oracle V7.X, you can alter the RBS to have them shrink to an predefined size by using the 'optimal' parameter. Then, the entire 200m pool would be available to a transaction,

Scott Overby                              sds_at_dataplusnet.com