SELECT inst_id, -- INST_ID NUMBER memory_allocated_knlasg, -- TOTAL_MEMORY_ALLOCATED NUMBER strmpool_size_knlasg, -- CURRENT_SIZE NUMBER sga_target_knlasg, -- SGA_TARGET_VALUE NUMBER shrink_phase_knlasg, -- SHRINK_PHASE NUMBER advice_disabled_knlasg -- ADVICE_DISABLED NUMBER FROM x$knlasg