RE: Used size of a datafile.
- From: "Vinod Gopinath BMMI IS" <vinodg@xxxxxxxxxxx>
- To: "Jesper Haure Norrevang" <jhn.aida@xxxxxx>
- Date: Sat, 8 Jan 2005 13:24:16 +0300
Thanks Jesper.
Vinod.
-----Original Message-----
From: Jesper Haure Norrevang [mailto:jhn.aida@xxxxxx]=20
Sent: Saturday, January 08, 2005 1:16 PM
To: Vinod Gopinath BMMI IS
Cc: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxx>
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
> --
> //www.freelists.org/webpage/oracle-l
>=20
--
//www.freelists.org/webpage/oracle-l
Other related posts:
