Modify SGA_MAX_SIZE SGA_TARGET

C:\\Documents and Settings\\whzl>sqlplus a/a@fwd as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on 星期三 8月 8 16:31:59 2012

Copyright (c) 1982, 2005, Oracle. All rights reserved.


连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> show sga

Total System Global Area 612368384 bytes
Fixed Size 1332348 bytes
Variable Size 187345796 bytes
Database Buffers 419430400 bytes
Redo Buffers 4259840 bytes

SQL> alter system set sga_target=1168m;
alter system set sga_target=1168m
*
第 1 行出现错误:
ORA-02097: 无法修改参数, 因为指定的值无效
ORA-00823: 指定的 sga_target 的值大于 sga_max_size

SQL> show parameter sga_max

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sga_max_size big integer 584M

我擦 最大值只有584M


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


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

SQL> alter system set sga_max_size=1170m scope=spfile;

系统已更改。

这个还要重启才可以，目前库还不能停额