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