Re: How to clear Rollback segments

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Tue, 4 Dec 2001 19:03:43 +1100
Message-ID: <3c0c834c$0$21612$afc38c87@news.optusnet.com.au>

That command will only work if OPTIMAL has been set (and if OPTIMAL *has* been set, it's a bit unlikely he'd need to manually shrink them in the first place), otherwise you have to specify a size to shrink *to*.

Hence:
alter rollback segment blah shrink to 4m;

Regards
HJR

--
Resources for Oracle: http://www.hjrdba.com
===============================


"Yurasis Dragon" <yurasis_spamNOSPAM_at_yahoo.com> wrote in message
news:kq1o0ukq2fmrb2tft38dv32ncmace2njem_at_4ax.com...


> Hmmm, not sure that it'll fix any "slow" problems but here's the syntax :

>

> alter rollback segment <WHATEVER> shrink;

>

>

> Through spittle and decaying teeth, "Michael Buresch"

<michael.buresch_at_t-online.de> grunted once then squawked :


>

> >Hallo,

> >

> >I have very big system rollback segments. How can I clean or reset it. My

> >system is very slow and it seems that that is the problem.

> >

> >Best regards,

> >Michael

> >

>

Received on Tue Dec 04 2001 - 02:03:43 CST