OraFAQ Forum: JDeveloper, Java & XML » ORA-00020 maximum number of processes exceeded

Home » Developer & Programmer » JDeveloper, Java & XML » ORA-00020 maximum number of processes exceeded

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-00020 maximum number of processes exceeded [message #110517]

Tue, 08 March 2005 06:35

sandy.adi
Messages: 2
Registered: March 2005

Junior Member

Hi All,
I am getting getting an SQLException, the error message is as follows
"ORA-00020 :maximum number of processes(150) exceeded". I dont know why this is happening. The requirement in our application is such that the maximum number of connections allowed should be limited to 20.
Can anybody tell me what are the possible reasons for this problem? It would also be very helpful if i get the solution as well.

Report message to a moderator

Re: ORA-00020 maximum number of processes exceeded [message #110576 is a reply to message #110517]

Tue, 08 March 2005 14:57

Frank Naude
Messages: 4581
Registered: April 1998

Senior Member

Hi,

Ask your DBA to login and see what those processes do and whom they belong to (v$process and v$session). Sessions may not be properly terminated, or might be using parallel processes.

Best regards.

Frank

Report message to a moderator

Re: ORA-00020 maximum number of processes exceeded [message #151797 is a reply to message #110517]

Mon, 19 December 2005 04:59

Chiranjeevi M
Messages: 1
Registered: December 2005
Location: hyd

Junior Member

plz give me solution for this problem as soon as possible

Report message to a moderator

Re: ORA-00020 maximum number of processes exceeded [message #151839 is a reply to message #151797]

Mon, 19 December 2005 07:03

orausern
Messages: 826
Registered: December 2005

Senior Member

Hi,

Oracle docs say following:

ORA-00020 maximum number of processes (string) exceeded

Cause: All process state objects are in use.

Action: Increase the value of the PROCESSES initialization parameter.

So ask your DBA to increase the PROCESSES parameter.

N.

Report message to a moderator

Previous Topic:	XDB.DBMS_XMLDOM.importNode function doesn't work
Next Topic:	How to pass an array from Java which maps to a PL/SQL table in oracle?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Nov 25 00:40:14 CST 2024