Re: Rollback segment too large

From: <lisa_at_e-dba.net>
Date: Fri, 27 Aug 1999 09:35:17 GMT
Message-ID: <7q5m4l$8fv$1@nnrp1.deja.com>

In article <SQlx3.4988$W5.442095_at_typhoon-sf.snfc21.pbi.net>, "Filip Hanik" <fhanik_at_digitalworkforce.net> wrote:
> Hi,
> I have a couple of rollback segments that are growing too fast.
> I had to do a lot of cleaning up and I set them to unlimited size and
now
> one rollback segment is 150Mb and the other one is around 100Mb.
> How do I clean these up?
>
> thanks
> Filip
>
>

have you set the 'optimal' size for your rollback segments? that setting should force a shrink to the specified size after the second transaction that causes the rb segment to extend past the defined limit.

also, from v 7.2 and up, you can issue a statement to shrink your rollback segments: alter rollback segment <rbseg> shrink;

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Aug 27 1999 - 04:35:17 CDT