From: Steve Phelan Subject: Re: Attentions DBAs - Does this make sense Date: 1997/07/09 Message-ID: <33C34EC0.7DDD5FD9@no-spam.pmcgettigan.demon.co.uk>#1/1 X-NNTP-Posting-Host: pmcgettigan.demon.co.uk [194.222.113.46] References: <5ogshq$82t@blush.jps.net> <5omihj$s58@news.euro.net> <01bc8c22$e82de5b0$0201010a@pretzel> X-Priority: 3 (Normal) Organization: Toneline Ltd. Newsgroups: comp.databases.oracle.server > Remember you can always re-org by exporting and importing (COMPRESS=Y > during exp). > > In our SAP environment, we try to grow no more than 1 extent per > segment > per month. We start off with a guesstimate NEXT set to perhaps 50% of > > INITIAL, then look for growth and adjust NEXT as needed to keep > extents > low. Look at the Oracle white papers on Space Management and the Advanced DBA Handbook. Using COMPRESS=Y is a very poor way of managing space in your database, and just proves that the storage settings you are using are incorrect. I always go for 16K, 32K, 64K, etc., etc. sized extents and *linear* growth, not using a PCTINCREASE figure which would give *exponential* growth. Again, this is as recommended by Oracle on their training courses and in their white papers. Just my opinion... Steve Phelan.