Re: Optimal Parameter

Arthur Merar ¼¶¼g©ó¤å³¹ <36e3d3f5.6833794_at_news.chaven.com>...
>
>Hello,
>
>Can you change or add the optimal parameter to a rollback segment
>without having to drop and recreate the rollback segment?

Yes, you can change the value of optimal using the SQL statement:

ALTER ROLLBACK SEGMENT rb1 STORAGE (OPTIMAL 5m);

Then, you can query V$ROLLSTAT to see the result. Received on Sun Mar 07 1999 - 03:31:51 CST