Dear Team,
After Application outage processes have been growing and it has hit ORA-00020: maximum number of processes (1000) exceeded.
Now that we have increased the Process value from 1000 to 1200 issue is resolved.
issue is that ora-00020: maximum number of processes 1000 exceeded ,database output shows that query against the views V$SESSION and V$PROCESS show different results.
we know that There is an application running and connecting to the database . The connection against the database is failing.
How can i know which user & terminal is spawning these processs on database server side? what is the Best way to identifiy the Client source/machine related to these process ?
but only 70 sessions show in v$ and gv$session? In v$process 687, the used slots show a terminal of unknown, and program of unknown, like a zombie process. With out that information, I can not find out what is calling the database, and burning up all my processes.
Example :
SQL> Select count(*) from v$session;
COUNT(*)
----------
70
SQL> select count(*) from v$process;
COUNT(*)
----------
687
I want to know the source Terminal/Client spawning these process (LOCAL=NO).
75D-XYZ]-oracle-> ps -ef |grep XYZ
oracle 25934 1 0 Sep 16 ? 0:01 oracleXYZ (LOCAL=NO)
oracle 20220 1 0 09:57:37 ? 0:01 oracleXYZ (LOCAL=NO)
oracle 22968 1 0 Sep 13 ? 0:01 oracleXYZ (LOCAL=NO)
oracle 23436 1 0 Sep 20 ? 0:00 oracleXYZ (LOCAL=NO)
oracle 21448 1 0 Sep 13 ? 0:00 oracleXYZ (LOCAL=NO)
oracle 7216 1 0 Sep 13 ? 0:00 oracleXYZ (LOCAL=NO)
oracle 10760 1 0 Sep 16 ? 0:00 oracleXYZ (LOCAL=NO)
oracle 8385 1 0 Sep 16 ? 0:01 oracleXYZ (LOCAL=NO)
oracle 22952 1 0 Sep 17 ? 0:00 oracleXYZ (LOCAL=NO)
oracle 10911 1 0 Sep 13 ? 0:00 oracleXYZ (LOCAL=NO)
oracle 14401 1 0 Sep 13 ? 0:00 oracleXYZ (LOCAL=NO)
oracle 6685 1 0 Sep 19 ? 0:01 oracleXYZ (LOCAL=NO)
oracle 7434 1 0 09:11:44 ? 0:00 oracleXYZ (LOCAL=NO)
oracle 13560 1 0 09:17:57 ? 0:00 oracleXYZ (LOCAL=NO)
oracle 7928 1 0 Sep 13 ? 0:00 oracleXYZ (LOCAL=NO)
oracle 3623 1 0 Sep 10 ? 0:54 ora_qmnc_XYZ
oracle 29210 1 0 Sep 13 ? 0:01 oracleXYZ (LOCAL=NO)
oracle 13431 1 0 Sep 17 ? 0:00 oracleXYZ (LOCAL=NO)
oracle 21495 1 0 Sep 16 ? 0:00 oracleXYZ (LOCAL=NO)
oracle 13567 1 0 09:17:58 ? 0:00 oracleXYZ (LOCAL=NO)
oracle 4782 1 0 09:42:40 ? 0:00 oracleXYZ (LOCAL=NO)
oracle 25398 1 0 Sep 16 ? 0:00 oracleXYZ (LOCAL=NO)
oracle 21958 1 0 Sep 19 ? 0:01 oracleXYZ (LOCAL=NO)
Thanks in Advance !!!
Krish