rollback segment

Hello,

I have a problem here with rollback segment.

I have a big tansaction which run once a month that required a big rollback segment of 30M. My normal production online application only required 4 rollback segments of total size of 16M in the RBS tablespace.

I have created a separate RBS2 tablespace of 40M to accomodate this monthly transaction. so at present I have 2 tablespaces for rollback segemnts and used up 56M in total of disk space.

Can anyone suggest a better way of dealing with this problem? Should I create one RBS tablespace of 40M and put both the production and the big rollback segments in it.

Any suggestions would be appreciated. You can send an email to

     nancy.teh_at_cc.monash.edu.au

Thank in advance...:)

Regards,
Nancy

Nancy Teh      
Shared Systems, Computer Centre,     
Monash University, Wellington Road,  
Clayton, Victoria 3168               
Australia 
Email:Nancy.Teh_at_cc.monash.edu.au                 


______________________________________________________________________