RE: Resizing RBSs in an LMT

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
Rich.Jesse_at_qtiworld.com              Quad/Tech International, Sussex, WI USA

> -----Original Message-----
> From: Tim Gorman [mailto:Tim_at_SageLogix.com]
> 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" <ORACLE-L_at_fatcity.com>
> 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
> > Rich.Jesse_at_qtiworld.com Quad/Tech
> International, Sussex, WI
> USA

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: Rich.Jesse_at_qtiworld.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).