Re: Rollback Segment Shrinkage Question

From: ARUN K C <arun_k_c_at_hotmail.com>
Date: Tue, 17 Oct 2000 16:01:12 GMT
Message-Id: <10652.119487@fatcity.com>

when a rollback segment extends beyond its optimal setting for the first time it does not shrink,the second time the rollback segment extends beyond its optimal setting,it shrinks,provided the second transaction forced the rolback segment to allocate a new extent.

>From: "Carle, William T (Bill), NBSO" <wcarle_at_att.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Rollback Segment Shrinkage Question
>Date: Tue, 17 Oct 2000 06:20:55 -0800
>
>Hi,
>
> At what point in time does a rollback segment shrink back to its
>optimal
>value?
>
>
>Bill Carle
>AT&T
>Database Administrator
>816-995-3922
>wcarle_at_att.com
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Carle, William T (Bill), NBSO
> INET: wcarle_at_att.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).

---

Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at Received on Tue Oct 17 2000 - 11:01:12 CDT