Re: free space

What your are looking at is free extents in your database. Contiguous extents are combined afaik in the view, all extents reported here should be non-contiguous. So you are looking at a database with very little and a bit fragmented free-space. The 2 block extents in DATA01 are probably never to be used anymore as the minimum segment is 5 Oracle blocks.

Hth,
Sybrand Bakker, Oracle DBA

Doug Cowles wrote:

> Can someone explain to me the output from dba_free_space?
> The columns seem simple enough...bytes is just blocks*
> oracle block size etc., I'm wondering though what the
> significance of this view is...the blocks aren't in sequence,
> why is that? Does these "free spaces" represent fragmentation?
> If so, what kind? Table, tablespace, empty extents?
> I appreciate any feedback.
> Thanks,
> Dc.
>
> TABLESPACE_NAME FILE_ID BLOCK_ID BYTES BLOCKS
> ------------------------------ --------- --------- --------- ---------
> SYSTEM 1 971 13025280 1590
> RBS 2 42 2809856 343
> DATA01 3 266 286720 35
> DATA01 3 122 16384 2
> DATA01 3 134 16384 2
> DATA02 5 2 1220608 149
> TEMP 6 2 2088960 255
> INDX01 4 12 958464 117
>
> 8 rows selected.
Received on Sun Nov 01 1998 - 08:32:45 CST