Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: max number of processes exceeded

Re: max number of processes exceeded

From: Roger Snowden <snowden_at_NOT.com>
Date: Tue, 22 Dec 1998 02:04:53 GMT
Message-ID: <367EFD70.DB3E9CAA@NOT.com>


Sounds like the obvious suspicion. If you are using a supported os and version, you can use MTS. MTS allows many connections to share a limited number of servers. Simple to implement, but mostly applicable to two-tier client/server waiting-for-a-user-to-click-a-mouse sort of applications.

The idea is that in such systems the server processes are waiting most of the time anyway. Pretty good deal for hooking up a relatively large number of interactive sessions of the OLTP variety. Not so good for batch processes, middleware application servers / transaction processors, or decision support applications execute huge sql statements and hit lots of rows per execution.

Check out the docs. Not tough to put together.

Roger

Roger Snowden
Sr. Systems Engineering Specialist
Oracle Corporation
rsnowden_at_NOTus.oracle.com <-- to reply, remove the obvious

Calvin Cheong wrote:
>
> Problem:
> Parameter "processes" is set to 60 currently. But still encountering
> oracle errors saying maximum number of processes exceeded. Thus
> cannot connect to database.
>
> Tried increasing processes parameter to higher number but then the
> database could not startup. Could it be that there is not enough
> resources (memory etc) to start up the database?
>
> thanks
Received on Mon Dec 21 1998 - 20:04:53 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US