更改Oracle SGA

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;