Already a member?
Sign in
Welcome! This is a website that everyone can build together. It's easy!
Determine Amount of PGA occupied by OLAP option Sessions
select 'OLAP Pages Occupying: '||
round((((select sum(nvl(pool_size,1)) from v$aw_calc)) / (select value from v$pgastat
where name = 'total PGA inuse')),2)*100||'%' info from dual union
select 'Total PGA In Use Size: '|| value/1024||' KB' info
from v$pgastat where name = 'total PGA inuse' union
select 'Total OLAP Page Size: '|| round(sum(nvl(pool_size,1))/1024,0)||' KB' info
from v$aw_calc union
select 'Total OLAP Page Hit Rate: '||
round(100*(sum(pool_hits)/(sum(pool_hits)+sum(pool_misses))),1)||'%' info
from v$aw_calc order by info desc;
INFO
--------------------------------
Total PGA In Use Size: 560361 KB
Total OLAP Page Size: 418227 KB
Total OLAP Page Hit Rate: 99.5%
OLAP Pages Occupying: 75%
round((((select sum(nvl(pool_size,1)) from v$aw_calc)) / (select value from v$pgastat
where name = 'total PGA inuse')),2)*100||'%' info from dual union
select 'Total PGA In Use Size: '|| value/1024||' KB' info
from v$pgastat where name = 'total PGA inuse' union
select 'Total OLAP Page Size: '|| round(sum(nvl(pool_size,1))/1024,0)||' KB' info
from v$aw_calc union
select 'Total OLAP Page Hit Rate: '||
round(100*(sum(pool_hits)/(sum(pool_hits)+sum(pool_misses))),1)||'%' info
from v$aw_calc order by info desc;
INFO
--------------------------------
Total PGA In Use Size: 560361 KB
Total OLAP Page Size: 418227 KB
Total OLAP Page Hit Rate: 99.5%
OLAP Pages Occupying: 75%
Latest page update: made by olapdba
, Apr 17 2008, 11:47 AM EDT
(about this update
About This Update
Edited by olapdba
95 words added
view changes
- complete history)
Edited by olapdba
95 words added
view changes
- complete history)
Keyword tags:
None
More Info: links to this page
