SELECT TOTAL_MEMORY_ALLOCATED, -- TOTAL_MEMORY_ALLOCATED NUMBER CURRENT_SIZE, -- CURRENT_SIZE NUMBER SGA_TARGET_VALUE, -- SGA_TARGET_VALUE NUMBER SHRINK_PHASE, -- SHRINK_PHASE NUMBER ADVICE_DISABLED -- ADVICE_DISABLED NUMBER FROM GV$STREAMS_POOL_STATISTICS WHERE INST_ID = USERENV('Instance')