Re: Do I really need more than 1 rollback segment?

Howard J. Rogers doodled thusly:

>
>Personally, I go for the Steve Adams school of thought on this one. I can't
>see any drawbacks (though I'm sure Jonathan will elaborate on the
>'additional I/O' idea) of large segments. It's the NUMBER of them that's
>the worry, to avoid contention issues.
>

Well, this is interesting. I used to get a lot of 1555 errs with 16 rlbsegs with 5M extents and 5 minextents. No optimal, shrink early morning and late arvo.

I've changed it to 16 rlbsegs, 20M extents, 20 minextents. Again, no optimal, same shrinks.
Not a single 1555 since then.
Application is mix of OLTP and DSS (Peoplesoft Financials).

Users are around 200, but actual connections are less than 50 (using an app server).

Cheers
Nuno Souto
nsouto_at_optushome.com.au.nospam Received on Wed Dec 12 2001 - 05:03:59 CST