Re: streams_pool_size

Posted by ErmanArslansOracleBlog on Jan 03, 2020; 2:47pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/streams-pool-size-tp7978p7980.html

It seems there is not enough room in your sga for letting the streams pools grow..
It seems your db buffer cache and shared pool in node 2 is bigger than node 1.
Basically, you should make some room in the SGA for extending the size of streams pool in node 2.

You may decrease the size of other pools(actually they are managed automatically in ASMM, but still if you set any values for them, then you may consider decreasing those values)
 
or

You can increase the sga_max_size.. (if your db is RAC, you should modify this parameter for all the instances -- database-wide setting)