This discussion is archived
2 Replies Latest reply: Feb 2, 2012 7:38 AM by user11981754 RSS

Streams and Memory Allocation

611900 Newbie
Currently Being Moderated
I am on 11.1.0.7 and have enabled Automatic Memory management. We have also allocated 500MB to Streams Pool size. Here are the database parameters -

memory_max_target=25G
memory_target=25G
db_keep_cache_size=2500M
streams_pool_size=500M
sga_target = 15G
pga_aggregate_target = 2G


Although it started with 500MB but at one point, SGA got allocated 20G of memory out of total 25G but out of this 20G, 13G was allocated to streams_pool_size.

Looking at the views it looks like Shared pool needs more memory and streams is only using 13% of this 13G but still Streams is not dynamically giving back free memory to Shared pool.

Question -

Is this how Streams should be holding back memory and not releasing it back. If yes, how can I flush the memory back to SGA if I know the Streams is using just fraction of what it is holding.

Thanks!

Legend

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