SQL> show parameter sga;
NAME TYPE VALUE
———– ——————————
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 2G
sga_target big integer 2G
SQL> alter system set sga_max_size=4096M scope=spfile;
System altered.
SQL> alter system set sga_target=4096M scope=spfile;
System altered.
RAC环境下需要增加 sid='*'
alter system set sga_target=20G scope=spfile sid=’*';
重启数据库
SQL>startup force;