Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Used size of a datafile.

Used size of a datafile.

From: Vinod Gopinath BMMI IS <vinodg_at_BMMI.com.bh>
Date: Sat, 8 Jan 2005 11:12:08 +0300
Message-ID: <C9239A40098E1B47815F48965A7D0BF13ADD51@BMMIXCH.BMMIHQ.Root.AD>


Content-Type: text/plain;

        charset="us-ascii"
Content-Transfer-Encoding: quoted-printable Group,
I have this query
<<<<=20
select distinct substr(a.TABLESPACE_NAME,1,10) "T N", substr(a.FILE_NAME,1,40) "F N",
 sum(a.bytes/1024/1024) "Size (M)"
 from dba_data_files a
 group by a.TABLESPACE_NAME, a.FILE_NAME  order by 1,2
>>>>

Gives me proper result, but I want to see how much of the space is used by each datafile. Which table should I refere for this query. I know this has been asked many a times, but one more time. TIA=20
Vinod.

--
http://www.freelists.org/webpage/oracle-l
Received on Sat Jan 08 2005 - 02:01:01 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US