Increase SGA size in 11g Rac Environement.

Dear Experts,

We have 2 node RAC environements with 11.2.0.4 database , RHEL 6.4,  Just share the information of both nodes SGA size.

Node 1 let's say ORCL1 & Node 2 ORCL2.  the SGA size are below

ORCL1 :

SQL> show parameter sga

NAME                                 TYPE        VALUE

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

lock_sga                             boolean     FALSE

pre_page_sga                      boolean     FALSE

sga_max_size                     big integer  6160M

sga_target                           big integer 0

SQL>

SQL> show parameter pga

NAME                                 TYPE        VALUE

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

pga_aggregate_target                 big integer 0

ORCL2 :

SQL> show parameter sga

NAME                                 TYPE        VALUE

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

lock_sga                             boolean      FALSE

pre_page_sga                      boolean      FALSE

sga_max_size                     big integer  3824M