Question

Oracle11g如何修改最大连接数

Answer 1

1. 用sys登录sql plus:

usename: sys as sysdba

password: ****

2. 查看最大连接数： select value from V$parameter where name="processes";

3. 查看当前连接数： select count (*) from V$process;

4. 把最大连接数改成300：alter system set processes=300 scope=spfile

5. 重启DB: shutdown immediate;

startup;