oracle for sde配置

1、修改oracle系统参数
alter system set sga_max_size=1640M scope=spfile;(Total physical RAM *80%*50%)

alter system set sga_target=1640M scope=spfile;

alter system set pga_aggregate_target=650M scope=spfile;(Total physical RAM *80%*20%)

alter system set pre_page_sga=true scope=spfile;

alter system set shared_pool_size=128M scope=spfile;

alter system set open_cursors=2000 scope=spfile;

alter system set session_cached_cursors=50 scope=spfile;

alter system set cursor_sharing=exact scope=spfile;

alter system set cursor_space_for_time=true scope=spfile;

 

2、关闭oracle
shutdown immediate;

 

3、启动oracle
startup open;