代码如下:
修改SGA
SQL> show parameter sga;
SQL> alter system set sga_max_size=1200M scope=spfile;
System altered.
修改PGA
SQL> show parameter pga
SQL> alter system set workarea_size_policy=auto scope=spfile;
SQL> show parameter workarea
SQL> alter system set pga_aggregate_target=128m scope=both;
查看进程连接数
select count(*) from v$process;
查看会话连接数
select count(*) from v$session;
查看查看汇总信息
show parameter processes;
查看修改连接数
alter system set processes=500 scope=spfile;