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')