Re: Help Fragmentation

rdtwb_at_annap.infi.net wrote:

>Hello
>
>Is there a sql command that can be executed that will tell me
>how fragmented a tablespace is?

select tablespace_name, count(*), max(bytes) from sys.dba_free_space
group by tablespace_name;

A completely unfragmented tablespace will have only one free space. Though you really don't need the max(bytes) part, it usually still comes in handy.

--
Chuck Hamilton
chuckh_at_dvol.com

Never share a foxhole with anyone braver than yourself