00039.Oracle查询表空间文件大小

select sum(d.bytes)/1024/1024/1024||'G' as total_bytes, d.tablespace_name
  from dba_data_files d
 where d.tablespace_name = 'UNDOTBS03'
 group by d.tablespace_name
 
 --
select * from v$tablespace