Re: Oracle 10g & tablespaces

"DA Morgan" <damorgan_at_psoug.org> wrote in message news:1117062970.747334_at_yasure...
> Matthias Hoys wrote:
>
>> I meant that there are a lot of "holes" in our tablespace map because of
>> the large differences between the initial/next extent size of all the
>> objects. I don't know if we will see a performance gain after the
>> migration but we will definitely win diskspace (30-40%) by "compacting"
>> the data.
>
> The subject says 10g. That means you are using LMT. So before you go
> fixing "holes" and claiming that initial and next extent sizes are
> different ... explain how you have done whatever it is you've done.
> What is your storage strategy? Because the above statements just don't
> compute.
> --

No no, I mean in our CURRENT db which is Oracle 8i with DM tablespaces. So I suspect we will gain diskspace by moving to LMT on 10g. Received on Thu May 26 2005 - 00:39:55 CDT