oracle查看表空间使用率的sql

电玩女神 2022-05-09 05:40 314阅读 0赞

oracle查看表空间使用率的sql:

select ‘RESULT=’ || df.tablespace_name “Tablespace”,
df.bytes / (1024 * 1024) “Total Size(MB)”,
sum(fs.bytes) / (1024 * 1024) “Free Size(MB)”,
round(sum(fs.bytes) * 100 / df.bytes) “% Free”,
round((df.bytes - sum(fs.bytes)) * 100 / df.bytes) “% Used”
from (select a.bytes, a.tablespace_name
from dba_free_space a
union all
select b.BYTES_FREE, b.tablespace_name from V$TEMP_SPACE_HEADER b) fs,
(select tablespace_name, sum(bytes) bytes
from dba_data_files
group by tablespace_name
union all
SELECT tablespace_name, SUM(bytes) total
FROM dba_temp_files
GROUP BY tablespace_name) df
where fs.tablespace_name = df.tablespace_name
group by df.tablespace_name, df.bytes

发表评论

表情：
评论列表 （有 0 条评论，314人围观）

还没有评论，来说两句吧...

相关阅读