3 Replies Latest reply: Feb 16, 2012 3:29 PM by Jocelyn Simard RSS

    STREAMS Memory Issue

    611900
      Hello,

      I have streams configured in my database - 11.1.0.7 (from one schema to another).

      I have given STREAMS_POOL_SIZE to 6GB

      But when I see the v$sgastat table I see it is using/needing 44GB
      SQL> select distinct pool,sum(bytes) "bytes" from v$sgastat group by pool;
      
      POOL                    bytes
      ------------ ----------------
                     22,579,722,424
      shared pool     8,595,198,976
      streams pool   47,247,030,168
      large pool        268,435,456
      java pool         268,435,456
      Need some help in understanding this. How it can be and what may be the cause.

      Your inputs will really be appreciated!

      Thanks!