Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Max connections in multithreaded application
Jim wrote:
> Is there a limit or parameter in Oracle that controls how many opened
> connections can a multithreaded process accomodate? In essence I have
> written a process that opens a connection to Oracle in multithreaded
> fashion, hence my process will be concurrently connected to the 'same'
> database multiple times, each time with a different thread all
> concurrently and the connections ought to be maintained opened during
> the lifetime of the process.
>
> I am hitting the problem where my 5th connection errors out
> indicating not to be able to establish a connection - but while the
> process is running I can separately connect to the oracle server using
> sqlplus (multiple times concurrently).
>
> My platform is Windows 2000 for Oracle and my application too.
>
> Thank you
>
> James.
I suspectd you will find it here:
########################################### # MTS ########################################### #circuits=0 #dispatchers="(PROTOCOL=TCP) (SERVICE=orabaseXDB)" #max_dispatchers=5 #max_shared_servers=20 #mts_circuits=0 #mts_dispatchers="" #mts_listener_address="" #mts_max_dispatchers=5 #mts_max_servers=20 #mts_multiple_listeners=FALSE #mts_servers=0 #mts_service="" #mts_sessions=0
-- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Fri Dec 05 2003 - 13:17:30 CST