Key:  additions   deletions
Showing 2 pages
Date/Time Made By Edit Note Type Scope
Apr 17 2008, 11:47 AM EDT olapdba
 
 edit 95 words added
Change:  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   View changes from previous version. (Word count: 114)
Apr 17 2008, 11:46 AM EDT olapdba
 
 create No content added or deleted.