在管理员用户下执行

select upper(f.tablespace_name) "表空间名",

d.tot_grootte_mb "表空间大小(m)",

d.tot_grootte_mb - f.total_bytes "已使用空间(m)",

to_char(round((d.tot_grootte_mb - f.total_bytes) / d.tot_grootte_mb * 100,

2),

'990.99')||'%' "使用比(%)",

f.total_bytes "空闲空间(m)",

f.max_bytes "最大块(m)"

from (select tablespace_name,

round(sum(bytes) / (1024 * 1024), 2) total_bytes,

round(max(bytes) / (1024 * 1024), 2) max_bytes

from sys.dba_free_space

group by tablespace_name) f,

(select dd.tablespace_name,

round(sum(dd.bytes) / (1024 * 1024), 2) tot_grootte_mb

from sys.dba_data_files dd

group by dd.tablespace_name) d

where d.tablespace_name = f.tablespace_name

order by f.tablespace_name;