Re: Rollback segments: Numberto create

You can check V$ROLLSTAT. GETS / WAITS should be > 1000. If not, add another rollback segment.

Peter Sharman wrote:

> Bill
>
> Rough rule of thumb is number of concurrent transactions divided by 4.
> There was at one stage a recommendation of never more than 50, but I've
> never seen an explanation of that, nor was it impossible to create more
> than 50.
>
> HTH
>
> Pete
>
> Bill Fee wrote:
>
> > Hello,
> >
> > Are there any guidelines on the number of rollback segments to create?
> >
> > Thanks in advance,
> >
> > A Newbie,
> > Bill Fee
>
> --
>
> Regards
>
> Pete
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Peter Sharman Email: psharman_at_us.oracle.com
> WISE Course Development Manager Phone: +1.650.607.0109 (int'l)
> Worldwide Internal Services Education (650)607 0109 (local)
> San Francisco
>
> "Controlling application developers is like herding cats."
> Kevin Loney, ORACLE DBA Handbook
> "Oh no it's not! It's much harder than that!"
> Bruce Pihlamae, long term ORACLE DBA
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Received on Wed Mar 03 1999 - 20:01:28 CST