Re: What is wrong with this rollback segment stmt ?

Did you make sure to take the System roll back segment offline so no user transactions try to use it ??????

Bill Timm
Asplundh Tree Expert Co.
bill_at_asplundh.com

aak2_at_Ra.MsState.Edu (Atif Ahmad Khan) wrote:

>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 Mon Feb 10 1997 - 00:00:00 CST