Thanks to all for your insights. Your ideas were helpful, as always. Regards
--- "Deshpande, Kirti" <[EMAIL PROTECTED]> 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 > > --- אדר_יחיאל <[EMAIL PROTECTED]> 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 > > [EMAIL PROTECTED] > > > > > -----Original Message----- > > > From: Karniotis, Stephen > [SMTP:[EMAIL PROTECTED]] > > > 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: [EMAIL PROTECTED] > > > 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: [EMAIL PROTECTED] > > > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).