-
查询 PGA 性能指标:
select name,value,100*( value
/decode((select sum(value) from v$sysstat
where name like 'workarea executions%'),0,null,
(select sum(value) from v$sysstat
where name like 'workarea executions%'))) pct
from v$sysstat where name like 'workarea executions%';
NAME VALUE PCT(%)
---------------------------------------------------------------- ---------- ----------
workarea executions -optimal 18315 100
workarea executions - onepass 0 0
workarea executions - multipass 0 0
http://hi.baidu.com/beijing6179/item/3257ec30e81e354d7d034b5a
查询 PGA 性能指标
最新推荐文章于 2024-01-23 14:37:16 发布