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?

As long as you have privileges to view the DBA_FREE_SPACE view belonging to SYS ....

select bytes from sys.dba_free_space
where tablespace_name = 'TSNAME';

where TS_NAME is the upper case name of the tablespace you want free space info about.

Michael

###################################################################
# Michael Abbey           Ottawa ON Canada      613 780 2364
###################################################################