oracle设置SGA
oracle设置SGA
Java代码
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 ;
系统已更改。
