oracle 设置SGA

SQL> show parameter sga;

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

系统已更改。

SQL> show parameter memory

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
hi_shared_memory_address             integer     0
memory_max_target                    big integer 820M
memory_target                        big integer 820M
shared_memory_address                integer     0
SQL> alter system set memory_target=300M scope=spfile ;

系统已更改。