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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Tim Gorman
  INET: Tim_at_SageLogix.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).