Re: sql question

From: Babu <vsbabu_at_erols.com>
Date: Wed, 10 Nov 1999 14:10:08 -0500
Message-ID: <80cfud$la2$1@autumn.news.rcn.net>

Here is the one I use. Check my website at http://www.csoft.net/~vsbabu/php.php3
for an online tool called OraHoo! which uses this and many other scripts to provide
online reporting via the web using PHP.

select a.TABLESPACE_NAME,

  a.BYTES bytes_used,
  b.BYTES bytes_free,
  b.largest,

  round(((a.BYTES-b.BYTES)/a.BYTES)*100,2) percent_used  from
(

   select TABLESPACE_NAME,
    sum(BYTES) BYTES
   from dba_data_files
   group by TABLESPACE_NAME
  )
  a,
(

   select TABLESPACE_NAME,
    sum(BYTES) BYTES ,
    max(BYTES) largest
   from dba_free_space
   group by TABLESPACE_NAME
  )
  b
 where a.TABLESPACE_NAME=b.TABLESPACE_NAME  order by ((a.BYTES-b.BYTES)/a.BYTES) desc

--
V.Satheesh Babu http://csoft.net/~vsbabu vsbabu_at_csoft.net
vsbabu_at_erols.com Received on Wed Nov 10 1999 - 13:10:08 CST