Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Rollback Segs

Rollback Segs

From: <kal121_at_yahoo.com>
Date: Wed, 11 Nov 1998 23:42:18 GMT
Message-ID: <72d7cq$j36$1@nnrp1.dejanews.com>


Hi,

I am creating 10 rollback segs, initial extent 50K, next extent 50K.

My question is, is it better to set maxexents UNLIMITED, and set the OPTIMAL to some value to provide shrinkage

OR

put a cap on the number maxextents to begin with, eg) maxextents = 250 and run the risk of running out of extents on a transaction.

Thanks,
KL

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Nov 11 1998 - 17:42:18 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US