admin管理员组文章数量:1642350
Based on Oracle 10g/11g
-- show summary permanent tablespace usage
SELECT t.tablespace_name
,t.total_perm_mb
,u.used_perm_mb
, (t.total_perm_mb - u.used_perm_mb) free_perm_mb
,ROUND ((t.total_perm_mb - u.used_perm_mb) / t.total_perm_mb * 100, 2)
free_percent
FROM (SELECT df.tablespace_name
, SUM (DECODE (df.autoextensible
,'YES', df.maxbytes
,'NO', BYTES
)
)
/ 1024
/ 1024 total_perm_mb
FROM dba_data_files df, dba_tablespaces dt
WHERE df.tablespace_name = dt.tablespace_name
AND dt.CONTENTS = 'PERMANENT'
GROUP BY df.tablespace_name) t
, (SELECT ds.tablespace_name
, SUM (ds.BYTES) / 1024 / 1024 used_perm_mb
FROM dba_segments ds
GROUP BY ds.tablespace_name) u
WHERE t.tablespace_name = u.tablespace_name
ORDER BY 5 ASC
本文标签: SpacepermanentORACLEQueriesrelated
版权声明:本文标题:Oracle Permanent Space Usage Related Queries 内容由热心网友自发贡献,该文观点仅代表作者本人, 转载请联系作者并注明出处:https://m.elefans.com/xitong/1729335635a1196943.html, 本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容,一经查实,本站将立刻删除。
发表评论