I agree with your disagree! Setting rollback segments 'as small as you can
make them' is just plain daft, and setting optimal at all is equally mad.
Optimal is there for those databases that don't have a full-time DBA, and as
such it can be a useful 'light-weight management' tool. But in a
properly-managed production database, it's an utterly lousy idea.
Regards
HJR
--
Resources for Oracle: http://www.hjrdba.com
===============================
"godmann" <allanwtham_at_yahoo.com> wrote in message
news:95cd51c.0112070034.1fde8cee_at_posting.google.com...
> Hi Andrew
>
> >>Rule of thumb: rollback segments should be as small as you can make
> >>them, with lots of extents. You don't want them too small that they're
> >>constantly extending however. Oh, and set an optimal size for them as
> >>well.
>
>
> Are you sure setting an optimal size is a good idea?? I kinda disagree
>
> Allan W. Tham
> DBA
Received on Fri Dec 07 2001 - 12:28:02 CST
