Re: Clearing-out rollback_data

Jim,

Try setting the optimal parameter for the rollback segments, this will cause the segments to shrink after they have reached the specified size. I think your problem is that when you update the rollback segments grow and maybe your rollback tablespace is set to autoextend so if your maxextents for rollback segments is high, they will continue to grow.

Richard

Jim Lake <nospam_at_oceangarden.com> wrote in article <3564A710.A56CF872_at_oceangarden.com>...
> I have a very static data warehouse, only updated once monthly. My
> rollback_data tablespace has grown, and I see no need for it's contents.
> How can I clear it out? Do I drop rollback segments?
>
> Thanks in advance for any advice and examples,
>
> Jim Lake.
>
>
Received on Thu May 21 1998 - 18:05:10 CDT