Re: Used size of a datafile.
- From: "biti_rainy" <biti_rainy@xxxxxxxxx>
- To: "vinodg@xxxxxxxxxxx" <vinodg@xxxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Sat, 8 Jan 2005 16:21:24 +0800
hi,Vinod Gopinath BMMI IS
you can join dba_extents to dba_data_files with file id and
sum(dba_extents.blocks).
Best regards
msn: biti_rainy@xxxxxxxxxxx
a dba from alibaba(china)
---- from the mail-----
>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
>
>.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
