VIEW: SYS.GV_$STREAMS_POOL_STATISTICS

Source

View Text - Preformatted

select "INST_ID","TOTAL_MEMORY_ALLOCATED","CURRENT_SIZE","SGA_TARGET_VALUE","SHRINK_PHASE","ADVICE_DISABLED","CON_ID" from gv$streams_pool_statistics

View Text - HTML Formatted

SELECT "INST_ID"
, "TOTAL_MEMORY_ALLOCATED"
, "CURRENT_SIZE"
, "SGA_TARGET_VALUE"
, "SHRINK_PHASE"
, "ADVICE_DISABLED"
, "CON_ID"
FROM GV$STREAMS_POOL_STATISTICS