Re: Free space in tablespace

From: <satarnag_at_microcad.com>
Date: Tue, 08 Sep 1998 21:27:33 GMT
Message-ID: <6t47g6$iq1$1@nnrp1.dejanews.com>

I never used SQL*DBA, but here is a script you can use. I got it from "Tuning Oracle" by Oracle Press, page 235. ISBN:0-07-881181-3

select b.file_id "File #"

     b.tablespace_name "Tablespace name",
     b.bytes "# bytes",
     (b.bytes - sum(nvl(a.bytes,0))) "# used",
     sum(nvl(a.bytes,0)) "# free",
     (sum(nvl(a.bytes,0))/(b.bytes))*100 "%free"

from sys.dba_free_space a, sys.dba_data_files b where a.file_id(+) = b.file_id
group by b.tablespace_name, b.file_id, b.bytes order by b.tablespace_name

Good Luck,
Satar Naghshineh

In article <6t2g75$8j8$1_at_nnrp1.dejanews.com>,   sanchang_at_my-dejanews.com wrote:
> Hi,
>
> I need to check how much free space it is available in a tablespace, I heard
> sqldba will do the job but I cannot find the command sqldba in my oracle_home
> directory. Can anyone advise me how I can check, maybe through sqlplus?
> Thanks in advance.
>
> best regards
>
> Sandie
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Tue Sep 08 1998 - 16:27:33 CDT