修改sga_max_size的大小

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

SQL> alter system set sga_max_size=500Mscope=spfile;

系统已更改。

SQL> show sga

Total System Global Area  171966464 bytes
FixedSize                  787988 bytes
VariableSize            145488364 bytes
DatabaseBuffers          25165824 bytes
RedoBuffers                524288 bytes
SQL> shutdown immediate;