Change: 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_idorder by username, sid, daws.aw_name;USER (SID,SERIAL#,SVR). .. INST_ID OLAP AW (ATTACHED) ... Genrtn----------------------- ----------   View changes from previous version. (Word count: 191)

Change: ('||sid||','||serial#||','||decode(server,'DEDICATED','D','S','SHD','U')||')'('||sid||','||serial#||','||decode(server,'DEDICATED','D','SHARED','S','U')||')' usn, owner||'.'||daws.aw_name||' ('||decode(attach_mode, 'READ WRITE', 'RW', 'READ ONLY', 'RO', 'MULTIWRITE', 'MW', 'EXCLUSIVE', 'XW', attach_mode)||')' aw, generationfrom dba_aws daws,v$aw_olap vawo, v$aw_calc vawc, v$session where daws.aw_number=vawo.aw_number and sid=vawo.session_id and vawc.session_id = sid order by username, sid, daws.aw_name;USER (SID,SERIAL#,SVR). OLAP AW (ATTACHED) ... Genrtn----------------------- ---------------------- ------SCOTT   View changes from previous version. (Word count: 173)

Change: ('||sid||','||serial#||','|| decode(server,'DEDICATED','D','S','SHD','U')||')'('||sid||','||serial#||','||decode(server,'DEDICATED','D','S','SHD','U')||')' usn, owner||'.'||daws.aw_name||' ('|| decode(attach_mode,('||decode(attach_mode, 'READ WRITE', 'RW', 'READ ONLY', 'RO', 'MULTIWRITE', 'MW', 'EXCLUSIVE', 'XW', attach_mode)||')' aw, generation from dba_aws daws,v$aw_olap vawo, v$aw_calc vawc, v$session where daws.aw_number=vawo.aw_number and sid=vawo.session_id and vawc.session_id = sid order by username, sid, daws.aw_name; USER (SID,SERIAL#,SVR) (SID,SERIAL#,SVR). OLAP AW (ATTACHED) ... Genrtn -----------------------   View changes from previous version. (Word count: 173)

Change: Created by olapdba Jan 9 2008, 2:01 PM EST for: no reason given