This discussion is archived
3 Replies Latest reply: Feb 16, 2012 1:29 PM by Jocelyn Simard RSS

STREAMS Memory Issue

611900 Newbie
Currently Being Moderated
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!

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points