Thanks to all for your insights.
Your ideas were helpful, as always.
Regards
- "Deshpande, Kirti" <kirti.deshpande_at_verizon.com>
wrote:
> With Oracle 9i & Auto Undo Management, Oracle
> allocates a default
> min_extents=2 for the undo segments. And there is
> nothing one can do to
> change it (other than continue using the rollback
> segment approach). The
> min_extents=20 guideline came about from Oracle's
> internal testing (a very
> controlled environment) to find ways to minimize
> ORA-1555 error.
>
> - Kirti
>
>
> -----Original Message-----
> Sent: Tuesday, January 15, 2002 2:15 PM
> To: Multiple recipients of list ORACLE-L
>
>
> min extents = 20 is not carved in stone. You
> allocate them with the
> number of extents that make sense for your database
>
> the problem is, as new releases come out, old
> "facts" change and people
> keep spreading them anyway
>
> --- אדר_יחיאל <adary_at_mehish.co.il> wrote:
> > Hello Viktor
> >
> > Regarding the rollback segments, I heard from
> Oracle that you need to
> > allocate them
> > with min extents=20.
> > This will cause users to get their own extents and
> the chance that a
> > new
> > update will overwrite
> > an old update that you need will decrease.
> > Check metalink. they have a paper on this error
> (if I remember
> > correctly)
> >
> > Yechiel Adar, Mehish Computer Services
> > adary_at_mehish.co.il
> >
> > > -----Original Message-----
> > > From: Karniotis, Stephen
> [SMTP:Stephen_Karniotis_at_compuware.com]
> > > Sent: Tue, January 15, 2002 8:05 PM
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: RE: ORA-01555: snapshot too old:
> rollback segment
> > number...
> > >
> > > You can export with CONSISTENT=N; a consistent
> view of the data
> > will not
> > > be
> > > achieved. You can also increase the size of
> your rollback segments
> > to
> > > accommodate large queries while updates are
> being performed. There
> > is not
> > > much else you can do on this one.
> > >
> > > Thank You
> > >
> > > Stephen P. Karniotis
> > > Technical Alliance Manager
> > > Compuware Corporation
> > > Direct: (248) 865-4350
> > > Mobile: (248) 408-2918
> > > Email: Stephen.Karniotis_at_Compuware.com
> > > Web: www.compuware.com
> > >
> > >
> > > -----Original Message-----
> > > Sent: Tuesday, January 15, 2002 12:20 PM
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: ORA-01555: snapshot too old: rollback
> segment number...
> > >
> > > Hi all,
> > >
> > > Last nignt when we were expring data for one of
> our
> > > databases, this error ocurred:
> > >
> > > ORA-01555: snapshot too old: rollback segment
> number
> > > 3 with name "R02") offset=(0).
> > >
> > > Now, we were able to once again export and load
> data
> > > this morning. And there was no error.
> > >
> > > What is the best aproach to try to eliminate
> this
> > > error in the future?
> > >
> > > Any suggestions apreciated.
> > >
> > > Thanks
> > >
> > > Regards
> > >
> > >
> > >
> > >
> __________________________________________________
> > > Do You Yahoo!?
> > > Send FREE video emails in Yahoo! Mail!
> > > http://promo.yahoo.com/videomail/
> > > --
> > > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > > --
> > > Author: Viktor
> > > INET: stant_98_at_yahoo.com
> > >
> > > Fat City Network Services -- (858) 538-5051
> FAX: (858) 538-5051
> > > San Diego, California -- Public Internet
> access / Mailing
> > Lists
> > >
> >
>
> > > To REMOVE yourself from this mailing list, send
> an E-Mail message
> > > to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> > > the message BODY, include a line containing:
> UNSUB ORACLE-L
> > > (or the name of mailing list you want to be
> removed from). You may
> > > also send the HELP command for other information
> (like
> > subscribing).
> > > --
> > > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > > --
> > > Author: Karniotis, Stephen
> > > INET: Stephen_Karniotis_at_compuware.com
> > >
> > > Fat City Network Services -- (858) 538-5051
> FAX: (858) 538-5051
> > > San Diego, California -- Public Internet
> access / Mailing
> > Lists
> > >
> >
>
> > > To REMOVE yourself from this mailing list, send
> an E-Mail message
> > > to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> > > the message BODY, include a line containing:
> UNSUB ORACLE-L
> > > (or the name of mailing list you want to be
> removed from). You may
> > > also send the HELP command for other information
> (like
> > subscribing).
> > >
>
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> > > This e-mail was scanned by the eSafe Mail
> Gateway
> > >
>
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> >
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > --
> > Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
> > INET: adary_at_mehish.co.il
> >
> > Fat City Network Services -- (858) 538-5051
> FAX: (858) 538-5051
> > San Diego, California -- Public Internet
> access / Mailing
> > Lists
> >
>
> > To REMOVE yourself from this mailing list, send an
> E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> ORACLE-L
> > (or the name of mailing list you want to be
> removed from). You may
> > also send the HELP command for other information
> (like subscribing).
>
>
> __________________________________________________
>
=== message truncated ===
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Viktor
INET: stant_98_at_yahoo.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Tue Jan 15 2002 - 23:37:02 CST