The problem isn't one of space - like you, I am quite happy
to 'waste' empty space to make administration more straightforward.
In the case of rollback segments, though, there is an I/O cost
to large rollback segments that can be avoided by keeping the
rollback segments at the optimal size.
--
Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
Howard J. Rogers wrote in message <39eacce2_at_news.iprimus.com.au>...
>Well, we'll have to agree to disagree. I see nothing wrong with letting the
>rollback segments rip during the day, and manually shrinking them at the
>dead of night, when no-one gives a damn, with a manual shrink command,
>suitably chron'd of course. Disk space is cheap (or should be considered
>so), and I hate to see anything get between me and my transaction, however
>"trivial" it might be.
>
>I agree with sizing for the general case.
>
>Regards
>HJR
>--
Received on Mon Oct 16 2000 - 12:50:47 CDT
