修改sga_max_size的大小

SQL> alter system set sga_max_size=500M scope=both;
alter system set sga_max_size=500M scope=both
                 *
第 1 行出现错误:
ORA-02095: 无法修改指定的初始化参数

SQL> alter system set sga_max_size=500M scope=spfile;

系统已更改。

SQL> show sga

Total System Global Area  171966464 bytes
Fixed Size                   787988 bytes
Variable Size             145488364 bytes
Database Buffers           25165824 bytes
Redo Buffers                 524288 bytes
SQL> shutdown immediate;