SGA memory parameter changes in Oracle Rac

This is how SGA memory can be changed in Oracle Rac

Database name: WASDBA
Node One : WASDBA1
Node Two : WASDBA2

Take backup of your parameter files and make sure you should have sufficent memory Available on your system.


One by one node:-
Connect To Node One :

alter system set sga_max_size=40g scope=spfile sid = 'WASDBA1';
alter system set sga_target=30g scope=spfile sid = 'WASDBA1';

Connect To Node Two :

alter system set sga_max_size=40g scope=spfile sid = 'WASDBA2';
alter system set sga_target=30g scope=spfile sid = 'WASDBA2';


Or In Another Way :
sql>alter system set sga_target=30g scope=spfile sid='*';
sql>alter system set sga_max_size=40g scope=spfile sid='*';


 PGA :

sql>alter system set pga_aggregate_target=10G scope =spfile sid='*';  --- Rac all node
sql>alter system set pga_aggregate_target=10G scope=both;  -- One by one