ITPub博客

首页 > Linux操作系统 > Linux操作系统 > oracle 重設置sga_target

oracle 重設置sga_target

原创 Linux操作系统 作者:aishu521 时间:2012-06-29 17:25:06 0 删除 编辑

SQL> alter system set sga_target=330M scope=both;
alter system set sga_target=330M scope=both
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-00823: Specified value of sga_target greater than sga_max_size

SQL>  alter system set sga_target=330M scope=spfile;

System altered
SQL>  shutdown immediate
SQL> startup
SQL> show parameter sga
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
lock_sga                             boolean     FALSE
pre_page_sga                         boolean     FALSE
sga_max_size                         big integer 332M
sga_target                           big integer 332M

 

SQL> show parameter sga

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
lock_sga                             boolean     FALSE
pre_page_sga                         boolean     FALSE
sga_max_size                         big integer 272M
sga_target                           big integer 272M
SQL> alter system set sga_max_size=300M scope=spfile;

System altered.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area  314572800 bytes
Fixed Size                  1219184 bytes
Variable Size             142607760 bytes
Database Buffers          163577856 bytes
Redo Buffers                7168000 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 300M
sga_target                           big integer 272M
SQL> alter system set sga_target=300M scope=both;

System altered.

SQL> show parameter sga

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
lock_sga                             boolean     FALSE
pre_page_sga                         boolean     FALSE
sga_max_size                         big integer 300M
sga_target                           big integer 300M
/u03/oradata/sgspcdb1
/u02/oradata/sgspcdb1

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/15187685/viewspace-734173/,如需转载,请注明出处,否则将追究法律责任。

上一篇: oracle修改進程數
请登录后发表评论 登录
全部评论

注册时间:2012-05-26

  • 博文量
    139
  • 访问量
    676809