Re: Table fragmentation

From: Richard Foote <richard.foote_at_bigpond.nospam.com>
Date: Thu, 13 Jan 2005 09:28:20 GMT
Message-ID: <UarFd.116874$K7.79305@news-server.bigpond.net.au>

"DA Morgan" <damorgan_at_x.washington.edu> wrote in message news:41e5cd68$1_2_at_127.0.0.1...
> ibm_97_at_yahoo.com wrote:
>
>> In 9.2.0.5, how can I detect if a table has blocks fragmentation or
>> not? If it is, is exp/imp the only way to fix it?
>>
>> Thanks a lot!
>
> If you are in 9.2.0.5 you shouldn't have any so what is the actual issue?

Hi Daniel

If you delete a whole bunch of random rows and your PCTUSED value is not set correctly or if you simply don't re-insert the same volume of deleted rows, then a table could still be very well fragmented even in 10g. The result being "wasted" or unused space below the HWM of the table which might benefit from a rebuild if for example FTS performance were an issue.

Rare, generally a result of a poor table definition, but still possible.

Cheers

Richard Received on Thu Jan 13 2005 - 03:28:20 CST