GV$AW_OLAP

select
a.inst_id,               -- INST_ID NUMBER
s.ksusenum,              -- SESSION_ID NUMBER
a.awnum,                 -- AW_NUMBER NUMBER
decode                   -- ATTACH_MODE VARCHAR2(10)
  (mod (a.at_mode, 128), 1, 'READ WRITE', 'READ ONLY'),
a.gen_xsawso,            -- GENERATION NUMBER
a.temp_lob_count,        -- TEMP_SPACE_PAGES NUMBER
a.temp_lob_read,         -- TEMP_SPACE_READS NUMBER
a.perm_lob_read,         -- LOB_READS NUMBER
a.changed_cache,         -- POOL_CHANGED_PAGES NUMBER
a.unchanged_cache        -- POOL_UNCHANGED_PAGES NUMBER
from
x$ksuse s,
x$xsawso a 
where
s.addr = a.KSSOBOWN and a.at_mode < 128
home |  up  |  mailbox