Skip to Main Content
  • Questions

  • shared_pool_size and the streams_pool_size parameters

Breadcrumb

XMAS_TREE

The AskTOM team is taking a break over the holiday season, so we're not taking questions or responding to comments. Please have a happy and safe festive season and as always, thanks for being a member of the AskTOM community.

Question and Answer

Chris Saxon

Thanks for the question.

Asked: July 02, 2024 - 10:10 pm UTC

Last updated: July 09, 2024 - 12:27 pm UTC

Version: Oracle 12.1.0.2

Viewed 1000+ times

You Asked

Can the shared_pool_size and the streams_pool_size parameters be set to the same value?

Both parameters are currently set to zero. I would like to set them both to 2g. I will need to use about 1.5g of the streams_pool memory for Golden Gate. Will this work?

Thanks much for your help.

and Connor said...

That depends.

If you are using "sga_target" than setting streams pool size will grab an allocation from the total sga, thus reducing shared pool (or other areas), so you would want to ensure sga_target is set appropriately before doing that.

If you're doing all these settings manually, then they can be set in isolation.

Nice blog post on the topic here

https://blogs.oracle.com/dataintegration/post/goldengate-how-to-manage-the-streams-pool-in-the-oracle-database

Rating

  (1 rating)

We're not taking comments currently, so please try again later if you want to add a comment.

Comments

A reader, July 04, 2024 - 4:33 pm UTC

Thank you for your response Connor. It helps a lot.
Chris Saxon
July 09, 2024 - 12:27 pm UTC

You're welcome
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's channel and Chris's channel from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.