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  

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
>I have this query
>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
> 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.



Other related posts: