改动后要加scope=spfile SQL> show parameter sga;NAME TYPE VALUE ------------------------------------ ---------------------- ------------------------------ lock_sga boolean FALSE pre_page_sga boolean FALSE sga_max_size big integer 600M sga_target big integer 276MSQL> alter system set sga_max_size = 650M scope = spfile;System altered.SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> startup ORACLE instance started.Total System Global Area 683671552 bytes Fixed Size 1282104 bytes Variable Size 570429384 bytes Database Buffers 109051904 bytes Redo Buffers 2908160 bytes Database mounted. Database opened. SQL> show parameter sga;NAME TYPE VALUE ------------------------------------ ---------------------- ------------------------------ lock_sga boolean FALSE pre_page_sga boolean FALSE sga_max_size big integer 652M sga_target big integer 276M SQL>
奇怪的是我运行show parameter sga 说我是无效的SQL语句~~
你可能不是在sqlplus下或pl/sql command下执行该语句.
select * from v$parameter where name = 'sga_max_size' for update 然后直接表里改
十分同意。 show parameter sga是sqlplus命令,不是sql语句,你得在pl/sql的命令窗口里运行。 要想改变sga_max_size的大小,需要输入 alter system set sga_max_size=xxM scope=spfile; 然后重启数据库就可以了,但不知你的问题是不是出在sga_max_size上。
也可以在OEM中直接修改参数 然后重起实例
那么在OEM里面直接修改参数...参数在那个目录下呢?谢谢~~找了半天没找到啊.
`
SQL> show parameter sga;NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 600M
sga_target big integer 276MSQL> alter system set sga_max_size = 650M scope = spfile;System altered.SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.Total System Global Area 683671552 bytes
Fixed Size 1282104 bytes
Variable Size 570429384 bytes
Database Buffers 109051904 bytes
Redo Buffers 2908160 bytes
Database mounted.
Database opened.
SQL> show parameter sga;NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 652M
sga_target big integer 276M
SQL>
你可能不是在sqlplus下或pl/sql command下执行该语句.
where name = 'sga_max_size'
for update
然后直接表里改
show parameter sga是sqlplus命令,不是sql语句,你得在pl/sql的命令窗口里运行。
要想改变sga_max_size的大小,需要输入
alter system set sga_max_size=xxM scope=spfile;
然后重启数据库就可以了,但不知你的问题是不是出在sga_max_size上。