Re: Used size of a datafile.

  • From: Jesper Haure Norrevang <jhn.aida@xxxxxx>
  • To: vinodg@xxxxxxxxxxx
  • Date: Sat, 08 Jan 2005 11:15:32 +0100

Vinod,

select
  f.tablespace_name,
  f.file_name,
  sum(e.bytes) / 1024 / 1024 MB
from dba_extents e, dba_data_files f
where e.file_id = f.file_id
group by f.tablespace_name, f.file_name
order by f.tablespace_name, f.file_name;

Regards
Jesper Haure Norrevang

----- Original Message -----
From: Vinod Gopinath BMMI IS <vinodg@xxxxxxxxxxx>
Date: Saturday, January 8, 2005 9:12 am
Subject: Used size of a datafile.

> 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 
> usedby 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.
> 
> 
> 
> 
> --
> //www.freelists.org/webpage/oracle-l
> 

--
//www.freelists.org/webpage/oracle-l

Other related posts: