What is wrong with this rollback segment stmt ?

I was having rollback segment blues. I wasn't sure what was wrong. So I did the following :

// Dropped the rollback segment tablespace after taking rollback segments
// offline.

drop tablespace RBS including contents ;

// Then created another one.

create tablespace RBS datafile 'rbsWG73' size 110M autoextend on next 1M maxsize 200M ;

// Created the four rollback segments and brought them back online.
create public rollback segment r01 tablespace RBS storage (initial 500K NEXT 500K OPTIMAL 25M MINEXTENTS 50 MAXEXTENTS 400); alter rollback segment r01 online ;
.
.

After a run few large transactions, the tablespace gets full and I start getting errors related to space problems on the system tablespace. I thought I would never run into problems with the above setup. The 4 rollback segments have an optimal size of 25M. The tablespace should never be more than 55% full. I checked available space on tablespace RBS then and it had .14% available. Now, after several hours it has about 50.2% available. Could anybody please point to what I did wrong ?

Thanks.

P.S. My system is Solaris X86 2.5.1. Oracle 7.3.2.2.0.

Atif Khan
aak2_at_ra.msstate.edu Received on Sun Feb 09 1997 - 00:00:00 CST