SQL> show parameter sga;

?

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> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area 4294967296 bytes<