Tuesday, August 7, 2018

How to increase the number of processes in Oracle DB

The solution to this question is to increase the number of processes :

  1. Open command prompt
  2. sqlplus / as sysdba
  3. startup force;
  4. show parameter processes; -- This shows 150 processes allocated, i will increase the count to 800 now
  5. alter system set processes=800 scope=spfile;

Tried and tested.