GV$AW_OLAP definition in Oracle Database 11.2
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)
    a."MODE", 0, 'READ ONLY', 1, 'READ WRITE', 2, 'MULTIWRITE', 3, 'EXCLUSIVE', 'UNKNOWN'),
  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 bitand(a.flags, 128) = 0

home |  up