So, if you haven't had any ORA-01555s, why would you worry? Is V$WAITSTAT showing any (significant) time spent waiting on "UNDO <anything>"? Are there any indications of problems?
If it ain't broke, don't buy trouble... ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, May 15, 2002 2:56 PM > I decided to create the RBSs in an 8.1.7 DB (HP/UX 11.0) in an LMT. I > remember having to do the trick of creating a temporary RBS in a non-LMT TS > first, then delete it when the others were created. Anyway, as I'm doing > some spot checking, I see about 1000 wraps on each of the RBSs in this > particular DB. From the Oracle Perf Tuning class, this tells me that my > next extents may be too small. > > But since this is in an LMT, the only way to increase the next extent size > on an RBS in an LMT is to recreate the whole TS, right? Or am I missing > something? At least we haven't hit any ORA-1555 errors in the past 9 months > since I hosed up these RBSs... :) > > TIA, > Rich Jesse System/Database Administrator > [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jesse, Rich > 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: Tim Gorman 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).
