RE: Rollback Segment tuning

From: Stephane Faroult <sfaroult_at_oriolecorp.com>
Date: Mon, 03 Jun 2002 00:53:17 -0800
Message-ID: <F001.00472170.20020603005317@fatcity.com>

('binary' encoding is not supported, stored as-is)
>
>Hi all,=0D
>=0D
>How to find out the smallest (minimal) transaction
>size from Dictionary vie=
>w or base tables =0D
>I try to set my OPTIMAL rollback segment base on
>smallest transaction size =
>to prevent ora-1555. since shrinking rollback
>segments may cause ora-1555.=
>=0D
>=0D
>=0D
>Thanks =0D
>=0D
>Sinardy=0D
>--=0D

Smallest ? Are you sure that you do not mean greatest ? Opinions diverge about OPTIMAL. As far as I am concerned I like it on databases where you may have occasionally very big changes. Look at V$ROLLSTAT. You have there the average amount of rollback segment used, as well as the high-water mark. You can use those values to derive something looking common-sensical. Alternatively, I think that there is in the 'X-rated' section of the Oriole site (http://www.oriole.com) something to set OPTIMAL automatically (don't worry, even with this name it contains nothing illegal in Singapore :-)). Even if you do not run the script as is, looking at what it does - and possibly questioning it - may give you the answer you are looking for.

Regards,

Stephane Faroult
Oriole

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

Received on Mon Jun 03 2002 - 03:53:17 CDT