select Total.Tname "表空间名称",Total.Total_Size "表空间大小",
Total.Total_Size - Used.free_size as "已使用大小",Used.Free_size as 表空间剩余大小,
Round((Total.Total_Size - Used.free_size) / Total.Total_Size,4)* 100 || '%' as 表空间使用率
from
(
-- 表空间数据文件的大小
select tablespace_name as TName,round(sum(user_bytes)/(1024*1024),1) as Total_size from dba_data_files
group by tablespace_name
) Total,
(
-- 表空间剩余的大小
select tablespace_name as TName,round(sum(bytes)/(1024*1024),1) as Free_size from dba_free_space
group by tablespace_name
) Used
where Total.TName = Used.TName(+)
Total.Total_Size - Used.free_size as "已使用大小",Used.Free_size as 表空间剩余大小,
Round((Total.Total_Size - Used.free_size) / Total.Total_Size,4)* 100 || '%' as 表空间使用率 from (-- 表空间数据文件的大小select tablespace_name as TName,round(sum(user_bytes)/(1024*1024),1) as Total_size from dba_data_files group by tablespace_name) Total,( -- 表空间剩余的大小select tablespace_name as TName,round(sum(bytes)/(1024*1024),1) as Free_size from dba_free_spacegroup by tablespace_name) Usedwhere Total.TName = Used.TName(+)
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/7656893/viewspace-445548/ ，如需转载，请注明出处，否则将追究法律责任。
下一篇：
SAP 工作组菜单
请登录后发表评论
登录
全部评论
