SQL語句： SQL> col tablespace format a20 SQL> select b.file_id "文件ID號", b.tablespace_name "表空間名", b.bytes "字節數", (b.bytes-sum(nvl(a.bytes,0))) "已使用", sum(nvl(a.bytes,0)) "剩余空間", sum(nvl(a.bytes,0))/(b.bytes)*100 "剩余百分比" from dba_free_space a,dba_data_files b where a.file_id=b.file_id group by b.tablespace_name,b.file_id,b.bytes order by b.file_id /
