Sign in or 
Share this
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%
olapdba |
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) |
|
Keyword tags:
None
More Info: links to this page
|
There are no threads for this page.
Be the first to start a new thread.
