oracle 配置sde,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;