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','S','SHD','U')||')' usn
, gvawo.inst_id
, owner||'.'||daws.aw_name||' ('||decode(attach_mode,'READ WRITE','RW','READ ONLY','RO','MULTIWRITE','MW','EXCLUSIVE','XW',attach_mode)||')' aw
, generation
from dba_aws daws, gv$aw_olap gvawo, gv$aw_calc gvawc, gv$session gvses
where daws.aw_number = gvawo.aw_number and
sid = gvawo.session_id and gvawc.session_id = sid and gvawo.inst_id = gvawc.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