Database Administration (MOSC)

MOSC Banner

ORA-00020: maximum number of processes (%s) exceeded

edited Mar 30, 2010 4:18AM in Database Administration (MOSC) 11 commentsAnswered
  Hi

i was not sure where to put this topic , if it is not a correct comunity i apologize.

 

we encounter ORA-00020: maximum number of processes (%s) exceeded

For the users whom try to connect via OCCI  (OCI connection i mean  )in their codes ,but number of sessions and processes are below limit.

 

RESOURCE_NAME                  CURRENT_UTILIZATION MAX_UTILIZATION INITIAL_AL LIMIT_VALU

---------- ------------------------------ ------------------- --------------- ---------- ----------

processes                                      522                                                790                             1400                   1400

sessions                                         566                                                 830                             1545                    1545

but i can easily make connection without any problem .

is there any bug in this regard

here is how they try to connect

 

FORMAT à createConnectionPool(poolUsername,poolPassWord,db,maxConn,minConn,incVal);

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center