去检查数据库的磁盘空间到底剩余多少

表空间数据文件满了或者系统磁盘满了都会报这个错误，可以看看这两块。
select ts.NAME,
path,
((df.TOTAL_SIZE-df.FREE_SIZE)*page/1024/1024)*100/df.MAX_SIZE||'%' AS "表空间使用率(最大扩展上限制为分母)",
(df.TOTAL_SIZE-df.FREE_SIZE)*page/1024/1024||'MB' AS "数据文件实际大小",
df.MAX_SIZE/1024.0||'GB' AS "数据文件最大扩展上限",
df.NEXT_SIZE||'MB' AS "数据文件下次扩展分配大小",
((df.TOTAL_SIZE-df.FREE_SIZE)*page/1024/1024)100/(df.TOTAL_SIZEpage/1024/1024)||'%' AS "表空间已分配大小使用率(已分配大小为分母)"
from v$datafile AS df
left join V$TABLESPACE AS ts
on ts.ID=df.GROUP_ID
order by ts.NAME;