Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Do I really need more than 1 rollback segment?

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

From: Hemant K Chitale <hkchital_at_singnet.com.sg>
Date: Sat, 8 Dec 2001 21:51:52 +0800
Message-ID: <9ut672$lql$1@violet.singnet.com.sg>


Why is setting optimal "equally mad" ? I've set OPTIMAL and haven't had a single ORA-1555 for more than a year. One Rollback Segment does grow as large as 400MB once a week when a particular job runs but shrinks back to 20MB -- it has to shrink so many extents only once a week. Other than that, yes, there are some shrinks etc but at least I have predictable rollback segment sizes.

Hemant K Chitale
http://hkchital.tripod.com

"Howard J. Rogers" <dba_at_hjrdba.com> wrote in message news:3c110a2a$0$29051$afc38c87_at_news.optusnet.com.au...
> I agree with your disagree! Setting rollback segments 'as small as you
can
> make them' is just plain daft, and setting optimal at all is equally mad.
> Optimal is there for those databases that don't have a full-time DBA, and
as
> such it can be a useful 'light-weight management' tool. But in a
> properly-managed production database, it's an utterly lousy idea.
>
> Regards
> HJR
> --
> Resources for Oracle: http://www.hjrdba.com
> ===============================
>
>
> "godmann" <allanwtham_at_yahoo.com> wrote in message
> news:95cd51c.0112070034.1fde8cee_at_posting.google.com...
> > Hi Andrew
> >
> > >>Rule of thumb: rollback segments should be as small as you can make
> > >>them, with lots of extents. You don't want them too small that
they're
> > >>constantly extending however. Oh, and set an optimal size for them as
> > >>well.
> >
> >
> > Are you sure setting an optimal size is a good idea?? I kinda disagree
> >
> > Allan W. Tham
> > DBA
>
>
Received on Sat Dec 08 2001 - 07:51:52 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US