Re: Q:Table Fragmentation. How do I reduce it?

On Wed, 18 Mar 1998 23:58:31 GMT, jan.coekelberghs_at_ping.be (Jan Coekelberghs) wrote:

>On 17 Mar 1998 11:43:49 GMT, GreMa_at_t-online.de (Matthias Gresz) wrote:
>
>>On Tue, 17 Mar 1998 17:10:45 +0800, Connor McDonald <mcdonald.connor.cs_at_bhp.com.au> wrote:
>>
>>Hi Connor,
>>why fragmentation does not affect performance? Everybody, every book claims that fragmantation is a performance penalty.
>>
>
>Not the good DBA's and not the good books.
 Are Oracle Press' books the bad ones?
>
>From "Advanced Oracle Tuning and Administration" :
>
>"Extents are often blamed for performance problems; however, their
>impact on performance is minimal and can be completely avoided. In
>fact, careful use of extents can improve your response time by
>distributing your I/O operations across multiple devices...".
>
>You should also read the white papers by Craig Shallahamer and Cary
>Millsap.
>
>Jan

--

Regards

Matthias Gresz    :-)

GreMa_at_T-online.de