oracle

create pfile='/home/oracle/sss.ora' from spfile;

create spfile from pfile='/home/oracle/sss.ora';

alter system set processes=3000 scope=spfile;
alter system set sessions=3000 scope=spfile;

alter system set sga_max_size=2048m scope=spfile;

alter system set sga_target=1536m scope=both;

alter system set pga_aggregate_target=768m scope=both;

alter system set memory_target =20480M scope=spfile;

alter system set memory_max_target =25600M scope=spfile;

alter system set memory_target =7680M scope=spfile;

alter system set memory_max_target =10240M scope=spfile;


posted @ 2016-12-09 14:36  星火spark  阅读(107)  评论(0编辑  收藏  举报