select
  streams_pool_size_for_estimate,          -- STREAMS_POOL_SIZE_FOR_ESTIMATE NUMBER
  streams_pool_size_factor,                -- STREAMS_POOL_SIZE_FACTOR NUMBER
  estd_spill_count,                        -- ESTD_SPILL_COUNT NUMBER
  estd_spill_time,                         -- ESTD_SPILL_TIME NUMBER
  estd_unspill_count,                      -- ESTD_UNSPILL_COUNT NUMBER
  estd_unspill_time                        -- ESTD_UNSPILL_TIME NUMBER
from
  gv$streams_pool_advice
where
  inst_id = USERENV('Instance')