오라클 프로세스 수 늘리기

How to increase the number of processes at database level in Oracle?

 

1.  Log on to the database as system administrator

•  In SQL Plus enter: "connect / as sysdba"

2. Set the number of processes to be desired value <num_processes>

• In SQL Plus "alter system set processes=<num_processes> scope=spfile"

3. Shutdown the database

• In SQL Plus "shutdown immediate"

4. Startup the database 

• In SQL Plus "startup"

5. Check the changes have taken effect.

• In SQL Plus "show parameter sessions" and "show parameter processes"

​출처 : http://knowledgebase.progress.com/articles/Article/P164971