Path: news.easynews.com!easynews!feed2.onemain.com!feed1.onemain.com!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!news1.optus.net.au!optus!spool01.syd.optusnet.com.au!spool.optusnet.com.au!210.49.20.119.MISMATCH!not-for-mail
From: nsouto@optushome.com.au.nospam (Nuno Souto)
Newsgroups: comp.databases.oracle.server
Subject: Re: Do I really need more than 1 rollback segment?
Date: Wed, 12 Dec 2001 11:03:59 GMT
Organization: D.C.S. P/L
Message-ID: <3c1738cd.1717929@news>
References: <9ume07$p3$1@panix3.panix.com> <3c0f98b6$1@usenetgateway.com> <95cd51c.0112070034.1fde8cee@posting.google.com> <3c110a2a$0$29051$afc38c87@news.optusnet.com.au> <f45d9b0.0112110438.414536d@posting.google.com> <3c166064$0$559$afc38c87@news.optusnet.com.au>
X-Newsreader: Forte Free Agent 1.21/32.243
Lines: 25
NNTP-Posting-Host: 203.164.180.25
X-Trace: 1008155251  5902 203.164.180.25
Xref: easynews comp.databases.oracle.server:127933
X-Received-Date: Wed, 12 Dec 2001 04:10:03 MST (news.easynews.com)

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@optushome.com.au.nospam