Whoops...forgot to mention that. <blush> CLASS COUNT TIME undo header 290 1241 undo block 751 168
I've got larger problems (HP's AutoRAID is slooooooow), but since this is #2 on the V$WAITSTAT list, I thought I could tackle it. I'm having second thoughts though...I've been known to cause myself much pain with the phrase "I can just...". ;) Thx! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > -----Original Message----- > From: Tim Gorman [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, May 15, 2002 4:36 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: Resizing RBSs in an LMT > > > 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).
