If you would like to determine what Analytic Workspaces (or Multidimensional Datatypes) are being accessed (attached) and in what mode (read only or read write) then consider using the script below.

set pages 500 lines 110
col usn format a23 heading "USER (SID,SERIAL#,SVR)"
col aw format a22 heading "OLAP AW (ATTACHED)"
col generation format 99999 heading "Genrtn"

select username||' ('||sid||','||serial#||','||decode(server,'DEDICATED','D','SHARED','S','U')||')'('||sid||','||serial#||','||decode(server,'DEDICATED','D','S','SHD','U')||')' usn,usn
, gvawo.inst_id
, owner||'.'||daws.aw_name||' ('||decode(attach_mode,('||decode(attach_mode,'READ 'READWRITE','RW','READ WRITE',ONLY','RO','MULTIWRITE','MW','EXCLUSIVE','XW',attach_mode)||')' 'RW',aw
, 'READgeneration
from ONLY',dba_aws 'RO',daws, 'MULTIWRITE',gv$aw_olap 'MW',gvawo, 'EXCLUSIVE',gv$aw_calc 'XW',gvawc, attach_mode)||')'gv$session aw,gvses generation
from dba_aws daws,v$aw_olapwhere vawo,daws.aw_number v$aw_calc= vawc,gvawo.aw_number v$sessionand
where sid = daws.aw_number=vawo.aw_numbergvawo.session_id and sid=vawo.session_idgvawc.session_id = sid and vawc.session_idgvawo.inst_id = sidgvawc.inst_id and gvses.inst_id = gvawc.inst_id
order by username, sid, daws.aw_name;


USER (SID,SERIAL#,SVR). .. INST_ID OLAP AW (ATTACHED) ... Genrtn
----------------------- ---------- ---------------------- ------
SCOTT (2385,1645,D) ... ........ 1 SCOTT.FOOBAR (RW) .... 38
SCOTT (2385,1645,D) ... ........ 1 SYS.AWXML (RO) ....... 2
SCOTT (2385,1645,D) ... ........ 1 SYS.EXPRESS (RO) ..... 2

SVR .... -- D = Dedicated , S = Shared
ATTACHED -- RO and RW is currently supported
........... MW and XW will not be observed until 11.1.x