Re: Tablespace fragmentation map

Antero.Elovaara" <antero.elovaara_at_ttgroup.fi> wrote:

>brooksa_at_logica.com wrote:
>>
>> I am trying to construct a query that will return a list of the total
>> sizes of blocks of contiguous free space in a tablespace.
>>
>> I have tried to use the dba_free_space table but cannot see how I can
>> achieve 'contiguous' part.
>>
>> I am using Oracle 6.0.32 (!) and would like to use this information for
>> assessing the optimal size for new a object's initial extent and I don't
>> want to defragment the tablespace!
>
>Every row in dba_free_space is a contiguos free extent.
>You try to find extents that form a contiguous area.
>Your problem (and more) is discussed in
>Oracle Magazine VOL 8 Number 4
>in Kevin Loneys excellent article
>"Online Free Space Defragmentation in Oracle Version 6"

I wouldn't even try it in SQL. Use PL/SQL instead. You can probably knock it out in about 10 minutes that way.

--
Chuck Hamilton
chuckh_at_ix.netcom.com

If at first you don't succeed, skydiving isn't for you.