Re: How to clear Rollback segments

From: Ganesh Raja <ganesh_at_gtfs-gulf.com>
Date: 3 Dec 2001 20:55:44 -0800
Message-ID: <a8aed4.0112032055.3644589c@posting.google.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;

But how do u resize the file after shrinking the same.

>
>
> 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 Mon Dec 03 2001 - 22:55:44 CST