Re: Extent Numbers (Was Re: Interview question)

From: Frank <fbortel_at_hotmail.com>
Date: 2000/07/26
Message-ID: <397EDD88.39FD2764@hotmail.com>#1/1

>snipped previous discussion>

> However, in general, fewer extents are good for your data dictionary. 'Nuff
> said!
>
> How about taking a quick trip to
> http://www.ixora.com.au/tips/creation/extents.htm for that full discussion
> of the issues you were after? If anyone can contradict Steve's findings, I
> haven't seen them do it.

Have you??? Qoute from this very page:

It is necessary to dwell on this briefly because some DBAs are reluctant to allow more
than a few extents in any segment in the mistaken belief that such "fragmentation" degrades performance. This myth was started by the Oracle documentation for the export utility in version 3, and is still
abroad.

What do the words "mistaken" and "myth" tell you?

'nuff said, indeed. Extents are not bad for performance, allocating them 'on-the-fly' is.

Frank Received on Wed Jul 26 2000 - 00:00:00 CDT