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!

Stream Pool Sizing and SGA AMM

540301Nov 11 2009 — edited Nov 13 2009

Hi DBAs,

Just a very general question. I have enabled the SGA AMM. So the Stream Pool Size is not defined. Sometime I am getting the warning for messages are spilling over. Should I increase the SGA or Disable the Automatic Memory Managent and define the Stream Pool Size explicitly. I am using Oracle 10.2.0.4 (single instance). I have heard from some experts that SGA AMM feature doesn't scale well some time but not sure how it manage the streams pool. If SGA AMM is not enabled then SGA only allocate 10% for Stream Pool. Total System RAM is 16GB and SGA Max and Target is 8 GB.

Should I increase the SGA AMM enabled or explicitly define the Stream Pool Size? Any suggestion please ..

Regards
-Samar-

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 11 2009

Added on Nov 11 2009

#performance-availability, #streams

7 comments

4,156 views