Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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.Received on Tue Dec 04 2001 - 00:02:07 CST