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;
1.数据库运行日志是否异常?
2.用户和表属性是否有限额?
https://eco.dameng.com/document/dm/zh-cn/pm/manage-objects
3.核查表空间等: