Skip to Main Content
  • Questions

  • shared_pool_size and the streams_pool_size parameters

Breadcrumb

We're taking a break this week as Connor and Chris will both be at CloudWorld, the premier Oracle conference of 2024. If you're in Vegas, please come say Hi or pop into our sessions

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 latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.