Re: Increase the size of rollback segments

Can you explain what the IO cost is? Cos I can't think of one.

Regards
HJR

--
--------------------------------------------------------------------------
Opinions expressed are my own, and not those of Oracle Corporation
Oracle DBA Resources:               http://www.geocities.com/howardjr2000
--------------------------------------------------------------------------

"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message
news:971718991.1058.0.nnrp-08.9e984b29_at_news.demon.co.uk...


>

> 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

> >--

>

>

>