Re: How to clear Rollback segments

Ganesh Raja wrote:
>
> 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
> > >
ALTER DATABASE DATAFILE '<file name goes here>' SIZE <new size goes here>

-- 
Ron Reidy
Oracle DBA
Reidy Consulting, L.L.C.