select t2.ts#,a.tablespace_name,a.file_id, a.file_name,a.bytes / 1024 / 1024 as total_mb,
t.fee_mb,
a.autoextensible
from sys.dba_data_files a
left join (select ts#,name from v$tablespace ) t2
on a.tablespace_name=t2.name
left join (select b.tablespace_name,b.file_id,sum(b.bytes)/1024/1024 as fee_mb from sys.dba_free_space b group by b.tablespace_name,b.file_id) t
on a.file_id = t.file_id
where a.tablespace_name='TEST0309'
转载于:https://www.cnblogs.com/iyoume2008/p/7735401.html
