重庆分公司
重庆分公司，新征程启航
为企业提供网站建设、域名注册、服务器等服务
[OracleScript]UndoUsagePerstatus
select tablespace_name,sum(decode(status,'EXPIRED',bytes,0)) "EXPIRED", round(sum(decode(status,'EXPIRED',bytes,0))/sum(bytes),4)*100 "Reused Ratio",
sum(decode(status,'UNEXPIRED',bytes,0)) "UNEXPIRED", sum(decode(status,'ACTIVE',bytes,0)) "ACTIVE",
round((sum(decode(status,'UNEXPIRED',bytes,0))+sum(decode(status,'ACTIVE',bytes,0)))/sum(bytes),4)*100 "Used Ratio"
from dba_undo_extents group by tablespace_name
order by 1;
网页名称：[OracleScript]UndoUsagePerstatus
网页链接：http://cqcxhl.cn/article/pgeijc.html
sum(decode(status,'UNEXPIRED',bytes,0)) "UNEXPIRED", sum(decode(status,'ACTIVE',bytes,0)) "ACTIVE",
round((sum(decode(status,'UNEXPIRED',bytes,0))+sum(decode(status,'ACTIVE',bytes,0)))/sum(bytes),4)*100 "Used Ratio"
from dba_undo_extents group by tablespace_name
order by 1;
网页名称：[OracleScript]UndoUsagePerstatus
网页链接：http://cqcxhl.cn/article/pgeijc.html