Re: Rollback segment/tablespace growth problem

"Mr. Chow Wing Siu" <wschow_at_Comp.HKBU.Edu.HK> wrote in message news:<9p2aj8$lue$1_at_net44p.hkbu.edu.hk>...
> Hi,
>
> I run Oracle 8 and designer 2000 few years. This month, the rbs
> tablespace was full twice, the size was increased from 50 to 100MB
> and then to 150MB. It is not an autoextend option.
>
> I wonder what makes it growth so fast. How do I tune the rbs
> to be "defragged" or "reused"? I do not think the tablespace
> size of rbs should be added anymore but it is nearly to do so again.

You could check the sizes of the rollback segments. If you did not set an optimal size, they will grow but never shrink. If this is not the problem, your applications transactions have grown so that they do need more rollback space. That could be normal, it could also be an application error.

Ronald.