Re: Tablespace and Segment Frag.

From: Kai Horstmann <horst_at_werum.de>
Date: Fri, 24 Jul 1998 00:32:23 +0200
Message-ID: <35B7B9F7.76419A5B@werum.de>

Software Administrator schrieb:
>
> Hello all,
>
> What is the quick and easy way to find out fragmentation for TB and
> its segments. I have been told to see two views.
>
> For Tablespace
> DBA_FREE_SPACE
>
> For Segments
> DBA_SEGMENTS
>
> What columns and values will tell if there is a fragmentation.
>
> Any help will help....
>
> Thanks,
> Sanjeev

DBA_FREE_SPACE shows you every single free block in the tablespaces. with DBA_EXTENTS you can see how your segments (Tables, indexes) are spread over the tablespaces in smaller or larger portions. DBA_SEGMENTS only shows you the sum of bytes of all extents that belong to the segment.

Kai Received on Thu Jul 23 1998 - 17:32:23 CDT