Re: Reorg Oracle 8 Partition tables

From: Steve Phelan <stevep_at_toneline.n-o-s-p-a-m.demon.co.uk>
Date: Sat, 20 Feb 1999 12:09:52 +0000
Message-ID: <36CEA610.B72DD467@toneline.n-o-s-p-a-m.demon.co.uk>

Couldn't agree more with your assertion.

But then there is more to extent managment than just total numbers, and I/O's. Fragmentation, extent reuse, predictive capacity planning all spring to mind, for instance. I know the original mail didn't touch these areas, but they should be dealt with at the same time - i.e. the physical database design and planning phase.

I suppose the 'real' answer for this question is to get people to read the Oracle White paper on Space Management, which deals in some detail with all of these areas regarding extent usage. It's a bit dated now, but the information is just as applicable. Available free from Oracle's main site.

Steve Phelan.

(Oracle 7 & 8 OCP).

Thomas Kyte wrote:

>
> the predominant thinking, and I see it lots, is that you have to constantly be
> striving to have objects in a single extent for some reason. thats wrong. Its
> not true. Its a myth. Ignore it. Let them grow.
>
> I agree with Peter. The original poster should really ask themselves "why am i
> doing this" to see if it *really* needs to be done.
Received on Sat Feb 20 1999 - 06:09:52 CST