dbf file size with sql

select value, name, null "size"
from v$parameter
where name like 'log_archive_dest%'
union all
select file_name,tablespace_name,bytes/1024/1024 Mb
from dba_data_files
union all
select file_name,tablespace_name,bytes/1024/1024 Mb
from dba_temp_files
union all
select member file_name,'log group 'a.group# tablespace_name
,b.bytes/1024/1024 Mb
from v$logfile a,v$log b
where a.group#=b.group#
union all
select name file_name,'control file' tablespace_name,0 Mb
from v$controlfile
order by 1,2