Re: Rollback segment/tablespace growth problem

From: Lawrence Simela <lsimela_at_mahalini.prestel.co.uk>
Date: Fri, 28 Sep 2001 04:14:34 +0100
Message-ID: <9p0qkm$omh$2@phys-ma.sol.co.uk>

Issue

ALTER ROLLBACK SEGMENT rollback_seg_name SHRINK TO new_size;

If you do not specify TO new_sized then it will be shrunk to OPTIMAL size or MINEXTENTS if OPTIMAL was not specified in storage clause hth
lawrence

"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.
>
> Thanks for idea.
>
> --
> Johnson Chow
Received on Thu Sep 27 2001 - 22:14:34 CDT