From: Michael Abbey <cpb4c52@nortel.ca>
Subject: Re: Help Fragmentation
Date: 1996/09/09
Message-ID: <32346C0D.30@nortel.ca>#1/1
references: <32342B3A.20@annap.infi.net>
content-type: text/plain; charset=us-ascii
organization: Bell Northern Research
mime-version: 1.0
newsgroups: comp.databases.oracle
x-mailer: Mozilla 2.0 (X11; I; HP-UX A.09.05 9000/712)



rdtwb@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
###################################################################