From: nitefrog@yahoo.com (The NiteFrog.-)
Subject: Can someone please give me a hand...
Date: 2000/07/07
Message-ID: <39666a8e.17141668@news.mindspring.com>#1/1
Organization: Frogs are US
X-Server-Date: 7 Jul 2000 23:51:03 GMT
Reply-To: nitefrog@yahoo.com
Newsgroups: comp.databases.oracle.server


Hello All,

Here is the query to be able to tell you if your tablespaces are
fragmented:

select tablespace_name, sum(bytes), max(bytes), count(tablespace_name)
  from dba_free_space
    group by tablespace_name
    order by tablespace_name;

Now I know that sum() if the total size of free space left in the
tablespace and the max() and count() not to sure.  Yes I am a rookie
DBA trying to learn th eropes so please bear with me.  Then it is
mentioned the if the contiguous is greater than 10 to 15 you should
defragment the tablespace.  So how do you tell?  Do you subtract
max-sum?  I just dont get it.

Thank again,

Kev.-