select file_name,tablespace_name,bytes/1024/1024 Mb
from dba_data_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;