Home » RDBMS Server » Server Administration » ORA Error::::ORA00020 Urgent Please help
ORA Error::::ORA00020 Urgent Please help [message #152256] Wed, 21 December 2005 23:58 Go to next message
gururaajaan
Messages: 5
Registered: December 2005
Junior Member
Dear All,
We are coming across ORA:00020 error...Immediately after taking the stock of Processes parameter in Init.ora..we found 150...On reading count of v$SESSION it gives 146....for a partiular user say xyz it has 119 connetionx but all of them are inactive...We are using ASP.Net application...Our client not able to access our data due the above problem...There may be nearly 1000-2000 logon for a Single user XYZ.

We are using Didcated serve Mode..
Oracle 9i R2
O/s Win 2003 Standard edition(SP 1)


Please help me out from the above problem....MOST Urgent



Re: ORA Error::::ORA00020 Urgent Please help [message #152283 is a reply to message #152256] Thu, 22 December 2005 03:20 Go to previous message
Frank Naude
Messages: 4587
Registered: April 1998
Senior Member
Hi,

$ oerr ora 00020
00020, 00000, "maximum number of processes (%s) exceeded"
// *Cause:  All process state objects are in use.
// *Action: Increase the value of the PROCESSES initialization parameter.


Also check the high water mark (max utilization) in SYS.V_$RESOURCE_LIMIT:

SQL> SELECT *
  2    FROM v$resource_limit
  3   WHERE resource_name = 'processes'
  4  /

RESOURCE_NAME   CURRENT_UTILIZATION MAX_UTILIZATION INITIAL_AL LIMIT_VALU
--------------- ------------------- --------------- ---------- ----------
processes                        19              25        150        150


Best regards.

Frank

Previous Topic: Question from OCP Dumps-Identifying constraint type in dba_constraints
Next Topic: Database
Goto Forum:
  


Current Time: Sun Jan 26 13:22:18 CST 2025