Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Streams and Memory Allocation

611900Aug 12 2011 — edited Feb 2 2012
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!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 1 2012
Added on Aug 12 2011
2 comments
246 views