If you would like to determine how much PGA (in use and max), OLAP Page Pool and OLAP Pages Hit Miss Ratio for every User accessing Analytic Workspaces then consider using the script below.

set lines 110 pages 500
col usn for a23 hea "USER (SID,SERIAL#,SVR)"
col pga_used for 9,990.9 hea "PGA MB|USED"
col pga_max for 9,990.9 hea "PGA MB|MAX"
col olap_pp for 9,990.9 hea "OLAP MB"
col olap_hrate for 99.9 hea "OLAP|Hit %"
bre on REPORT;

comp avg lab Average min lab Minimum max lab Maximum of olap_hrate on REPORT;
comp avg lab Average sum lab Total min lab Minimum max lab Maximum of pga_used on REPORT;
comp avg lab Average sum lab Total min lab Minimum max lab Maximum of pga_max on REPORT;
comp avg lab Average sum lab Total min lab Minimum max lab Maximum of olap_pp on REPORT;

select vs.username||' ('||vs.sid||','||vs.serial#||','||
decode(server,'DEDICATED','D','S','SHD','U')||')' usn,
round((pga_used_mem)/1024/1024,1) pga_used,
round((pga_max_mem)/1024/1024,1) pga_max,
round((pool_size)/1024/1024,1) olap_pp,
round(100*((pool_hits)/((pool_hits)+(pool_misses))),1) olap_hrate
from v$process vp, v$session vs, v$aw_calc va
where va.session_id = vs.sid and vp.addr = vs.paddr
order by vs.username, vs.sid, vs.serial#;

..........................PGA MB...PGA MB...........OLAP
USER (SID,SERIAL#,SVR)......USED......MAX..OLAP MB Hit %
----------------------- -------- -------- -------- -----
DICK (158,26077,D)..........27.0.....49.6......3.6. 99.3
LAURA (128,62545,D)..........4.7.....13.1......0.3 .97.6
TESTA (133,8893,D)..........37.0....104.1......8.3 .98.7
TESTB (135,1224,D)...........5.3.....24.1......0.3 .97.6
STEVE (134,62058,D).........18.0.....27.7......4.2 .98.7
SYS (132,48474,D)...........20.1.....28.5 .....4.2 .98.7
SYSTEM (129,10727,D)........17.0.....51.5 .....2.9 .98.8
........................-------- -------- -------- -----
Average.....................18.4.....42.7......3.4..98.5
Minimum......................4.7.....13.1..... 0.3 .97.6
Maximum.....................37.0....104.1......8.3 .99.3
Total......................129.1....298.6.....23.8