Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: max number of processes exceeded
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