Re: sql question

From: Babu <vsbabu_at_erols.com>
Date: 1999/11/10
Message-ID: <80cfud$la2$1_at_autumn.news.rcn.net>#1/1

Here is the one I use. Check my website at http://www.csoft.net/~vsbabu/php.php3
[Quoted] for an online tool called OraHoo! which uses this and many other scripts to provide
[Quoted] 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 - 00:00:00 CET