select a.tablespace_name "表空间名",
total /1024/1024"表空间大小单位M",
free /1024/1024"表空间剩余大小单位M",(total - free)/1024/1024"表空间使用大小单位M",round((total - free)/ total,4)*100"使用率%"from(select tablespace_name,sum(bytes) free
from DBA_FREE_SPACE
groupby tablespace_name) a,(select tablespace_name,sum(bytes) total
from DBA_DATA_FILES
groupby tablespace_name) b
where a.tablespace_name = b.tablespace_name;
查看表空间是否自动扩容
select tablespace_name,file_name,autoextensible from dba_data_files where tablespace_name='CORE_DATA';