Re: Tablespace fragmentation map

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!
>
> --
> Adrian Brooks
>
> Any views expressed are my own and not of my employer.

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"

-- 
Antero Elovaara                     antero.elovaara_at_ttgroup.fi
Carelcomp Power Oy
P.O.Box 46                        
01601 Vantaa
Finland

All possible opinions are only mine, not my employer