GV$STREAMS_POOL_ADVICE

select
inst_id,                 -- INST_ID NUMBER
size_knlarow,            -- STREAMS_POOL_SIZE_FOR_ESTIMATE NUMBER
round                    -- STREAMS_POOL_SIZE_FACTOR NUMBER
  (size_knlarow / basesize_knlarow, 4),
spillcnt_knlarow,        -- ESTD_SPILL_COUNT NUMBER
spilltime_knlarow,       -- ESTD_SPILL_TIME NUMBER
unspillcnt_knlarow,      -- ESTD_UNSPILL_COUNT NUMBER
unspilltime_knlarow      -- ESTD_UNSPILL_TIME NUMBER
from
x$knlarow
home |  up  |  mailbox