SELECT a.tablespace_name "表空间名",
total "表空间大小",
free "表空间剩余大小",( total - free )"表空间使用大小",Round(( total - free )/ total,4)*100"使用率 %"FROM(SELECT tablespace_name,Sum(bytes/(1024*1024)) free
FROM DBA_FREE_SPACE
GROUPBY tablespace_name) a,(SELECT tablespace_name,Sum(bytes/(1024*1024)) total
FROM DBA_DATA_FILES
GROUPBY tablespace_name) b
WHERE a.tablespace_name = b.tablespace_name;
查询表空间对应地址
select tablespace_name, file_id, file_name,round(bytes/(1024*1024),0) total_space from dba_data_files orderby tablespace_name;