Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Attentions DBAs - Does this make sense
>> 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