Used size of a datafile.
- From: "Vinod Gopinath BMMI IS" <vinodg@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Sat, 8 Jan 2005 11:12:08 +0300
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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
