Re: How to clear Rollback segments

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 Mon Dec 03 2001 - 17:15:30 CST