目录
linux的oracle修改连接数
1、关闭监听
lsnrctl stop
2、查看当前会话数
查询数据库设置的最大连接数
show paratemer processes;
查看当前进程
sqlplus / as sysdba
select b.MACHINE, b.PROGRAM , count(*) from v$process a, v$session b where a.ADDR = b.PADDR and b.USERNAME is not null group by b.MACHINE , b.PROGRAM order by count(*) desc;
3、增加连接数
alter system set processes = 1000 scope = spfile;
alter system set sessions= 1500 scope = spfile;
4、重启数据库使配置生效
shutdown immediate;
startup;
5、重新查询数据库设置的最大连接数
sqlplus / as sysdba
show paratemer processes;
6、重启监听
lsnrctl start
标签:processes,linux,连接数,查询数据库,oracle,监听
From: https://www.cnblogs.com/lgxdev/p/16962265.html