RE: Rollback Segment Shrinkage Question

"Oracle concepts" manual says in chapter 4:

"If a transaction needs to continue writing rollback information from one
extent to another extent in the rollback segment, Oracle compares the current size of the rollback segment to the segment's optimal size. If the rollback segment is larger than its optimal size, and if the extents immediately following the extent just filled are inactive, then Oracle deallocates consecutive nonactive extents from the rollback segment until the total size of the rollback segment is equal to or close to, but not less than, its optimal size. Oracle always frees the oldest inactive extents, as these are the least likely to be used by consistent reads. "

My question for the gurus: Does that mean that if no transactions need to allocate more than one extent in the RBS, it will never shrink back automatically?

TIA, Dr. Nikolay Kumanov

MIS Manager, Zeitungsgruppe Bulgarien GmbH 47, Tsarigradsko chaussee, Sofia 1504, Bulgaria phone: +(359-2)4339-643, fax: +(359-2)946-1286 mailto:nkumanov_at_zgb.bg

"Show me a completely smooth operation and I'll show you someone who's
covering mistakes. Real boats rock." - Frank Herbert, "Chapterhouse: Dune"

-----Original Message-----
From: Carle, William T (Bill), NBSO [mailto:wcarle_at_att.com] Sent: Tuesday, October 17, 2000 5:21 PM
To: Multiple recipients of list ORACLE-L Subject: Rollback Segment Shrinkage Question

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