Re: Oracle Myths

"Michael Brown" <mbrown_at_japhi.com> wrote in message news:laraeu4j49vmdqgj41sobavajlhf3o27h6_at_4ax.com...
> On 17 May 2002 07:46:19 -0700, gmirsky_at_optonline.net (Gregory N.
> Mirsky) wrote:
>
>
> PCTIncrease should be non-zero. If PCTIncrease is anything other
than
> 0 for both the tablespace and the objects in the tablespace,
> fragmentation occurs. Since the number of extents has no bearing on
> performance (yes this is arguable if the number is in the tens of
> thousands), the best utilization of the space in a tablespace is if
> every extent is the same size. This allows any free extent in the
> tablespace to be used when a new extent is needed. There is no
reason
> to coalesce since the only fragmentation is on datafile boundaries
(an
> extent must be in a single datafile).

I found the following doc very instructional:

    http://technet.oracle.com/deploy/availability/pdf/defrag.pdf

--
Pablo Sanchez, High-Performance Database Engineering
mailto:pablo_at_hpdbe.com
http://www.hpdbe.com
Available for short-term and long-term contracts