optimal size for rollback

Hi

I have been reading quite a bit about rollback segments and I kinda agree that setting optimal size is not quite a good idea. That shows that a dba has not done his job to find out what the correct size of the rollback segment should be.
This is what I am thinking of doing and let me know if it does not make sense.

initial 1M
next 1M
minextents 6
optimal 6M

The reason I want to set optimal is because occasionally I have some big jobs that cause a rollback segment to grow. However, I do not want to have to manually go in and re-set its size once the jobs are done. So, I thought setting optimal will take care of it. What do you experts think?

rgds
Daud Received on Fri Sep 13 2002 - 05:05:40 CDT