select
session_id, -- SESSION_ID NUMBER
aw_number, -- AW_NUMBER NUMBER
attach_mode, -- ATTACH_MODE VARCHAR2(10)
generation, -- GENERATION NUMBER
temp_space_pages, -- TEMP_SPACE_PAGES NUMBER
temp_space_reads, -- TEMP_SPACE_READS NUMBER
lob_reads, -- LOB_READS NUMBER
pool_changed_pages, -- POOL_CHANGED_PAGES NUMBER
pool_unchanged_pages -- POOL_UNCHANGED_PAGES NUMBER
from
gv$aw_olap
where
inst_id = USERENV('Instance')