select fs.tablespace_name tablespace,
(df.totalspace - fs.freespace) used_mb,
fs.freespace free_mb,
df.totalspace total_mb,
round(100 * (fs.freespace / df.totalspace)) pct_free
from (select tablespace_name, round(sum(bytes) / 1024 / 1024) totalspace
from dba_data_files
group by tablespace_name) df,
(select tablespace_name, round(sum(bytes) / 1024 / 1024) freespace
from dba_free_space
group by tablespace_name) fs
where df.tablespace_name = fs.tablespace_name
and fs.tablespace_name = 'APPLSYSD';
(df.totalspace - fs.freespace) used_mb,
fs.freespace free_mb,
df.totalspace total_mb,
round(100 * (fs.freespace / df.totalspace)) pct_free
from (select tablespace_name, round(sum(bytes) / 1024 / 1024) totalspace
from dba_data_files
group by tablespace_name) df,
(select tablespace_name, round(sum(bytes) / 1024 / 1024) freespace
from dba_free_space
group by tablespace_name) fs
where df.tablespace_name = fs.tablespace_name
and fs.tablespace_name = 'APPLSYSD';
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/10359218/viewspace-678550/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
