oracle 重設定sga_target

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/，如需轉載，請註明出處，否則將追究法律責任。