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')