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

    STREAMS Memory Issue


      I have streams configured in my database - (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
      ------------ ----------------
      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!