Oracle11g如何修改最大連接數?
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;