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;


原文地址:https://www.cnblogs.com/sparkbj/p/6149439.html