RE: Used size of a datafile.

From: Vinod Gopinath BMMI IS <vinodg_at_BMMI.com.bh>
Date: Sat, 8 Jan 2005 13:24:16 +0300
Message-ID: <C9239A40098E1B47815F48965A7D0BF13ADDA6@BMMIXCH.BMMIHQ.Root.AD>

Thanks Jesper.
Vinod.

-----Original Message-----
From: Jesper Haure Norrevang [mailto:jhn.aida_at_cbs.dk]=20 Sent: Saturday, January 08, 2005 1:16 PM To: Vinod Gopinath BMMI IS
Cc: oracle-l_at_freelists.org
Subject: Re: Used size of a datafile.

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 =3D 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_at_BMMI.com.bh> Date: Saturday, January 8, 2005 9:12 am Subject: Used size of a datafile.

> Content-Type: text/plain;
> charset=3D"us-ascii"
> Content-Transfer-Encoding: quoted-printable
> Group,
> I have this query
> <<<<=3D20
> 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=3D20
> Vinod.

>=20
>=20
>=20
>=20

> --
> http://www.freelists.org/webpage/oracle-l
>=20

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

Received on Sat Jan 08 2005 - 04:13:08 CST