DBA Data[Home] [Help]

VIEW: SYS.GV_$AW_OLAP

Source

View Text - Preformatted

select "INST_ID","SESSION_ID","AW_NUMBER","ATTACH_MODE","GENERATION","TEMP_SPACE_PAGES","TEMP_SPACE_READS","LOB_READS","POOL_CHANGED_PAGES","POOL_UNCHANGED_PAGES","CON_ID" from gv$aw_olap
View Text - HTML Formatted

SELECT "INST_ID"
, "SESSION_ID"
, "AW_NUMBER"
, "ATTACH_MODE"
, "GENERATION"
, "TEMP_SPACE_PAGES"
, "TEMP_SPACE_READS"
, "LOB_READS"
, "POOL_CHANGED_PAGES"
, "POOL_UNCHANGED_PAGES"
, "CON_ID"
FROM GV$AW_OLAP