GV$STREAMS_POOL_STATISTICS definition in Oracle Database 11.2
GV$STREAMS_POOL_STATISTICS

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

home |  up