Tag: process

But Before this , i am gonna show you some steps to check the process via OS and Database LETS BEGIN :

• check if the number of connections reaches the database’s  process parameter using following Unix command:

ps -ef | grep oracleSID | grep -v grep | wc -l
or
ps aux | grep oracleSID | grep -v grep | wc -l

•  check if the number of connections reaches the database’s  process parameter using following Database Command :

SQL> show parameter processes

NAME                TYPE        VALUE
------------------ ----------- -------
processes           integer     150

SQL> select count(*) from v$process;

  COUNT(*)
----------
       149

SQL> show parameter sessions

NAME                TYPE        VALUE
------------------ ----------- -------
Session              integer     150

SQL> select count(*) from v$session;

  COUNT(*)
----------
       149

Now We need To Increase the Both Parameter By :

SQL> alter system set processes=300 scope=spfile;

System altered.

SQL> alter system set Session=300 scope=spfile;

System altered. 

If this Solution Not Work For you , Try this One :