Skip to Main Content
  • Questions
  • shared_pool_size and the streams_pool_size parameters

Breadcrumb

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)

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