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

Home -> Community -> Usenet -> c.d.o.server -> Re: Attentions DBAs - Does this make sense

Re: Attentions DBAs - Does this make sense

From: Brett C <zgeist.diespammer_at_ee.net>
Date: 1997/07/09
Message-ID: <5q02s0$f8p@news1.ee.net>#1/1

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

There is a transaction in SAP (DB02, I believe) that will give you segment growth history. I took over administration of some SAP databases and used this information to resize some badly-tuned segments. Extent growth on some went from 8 extents a week to 1 extent a month.

Just my .02

Brett
zgeist.diespammer_at_ee.net
remove diespammer to reply Received on Wed Jul 09 1997 - 00:00:00 CDT

Original text of this message

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