streams_pool_size

Posted by Roshan on Jan 02, 2020; 3:20pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/streams-pool-size-tp7978.html

Oracle DB 12.1.0.2
RAC 2 nodes
Solaris 11.4

Hi Erman,

I have set the streams_pool_size to 3G on first node. On the second node I am getting error below despite sufficient memory exists on the Server.

on the second node I am getting

SQL> alter system set streams_pool_size=3G sid='inst12' scope=both;

alter system set streams_pool_size=3G sid='inst12' scope=both

*

ERROR at line 1:

ORA-02097: parameter cannot be modified because specified value is invalid

ORA-04033: Insufficient memory to grow pool

SQL> show parameter sga

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

allow_group_access_to_sga            boolean     FALSE

lock_sga                             boolean     FALSE

pre_page_sga                         boolean     TRUE

sga_max_size                         big integer 11200M <============== 11.2G allocated for SGA

sga_target                           big integer 11200M

unified_audit_sga_queue_size         integer     1048576

 Kindly advise why I am not able to set it to 3G on second node.

Thanks.