The connection limit for specific providers is specified in the 
serverconfig.ini file.
Please check this setting:

DataConnectionPoolSizeCustom

Example of the above:
DataConnectionPoolSizeCustom = Autodesk.Oracle:10

If the above setting is not limiting the # of Oracle connections then the 
connection limit is controlled at the Oracle DB side.

Note: Changing the setting in the serverconfig.ini file DOES NOT override what 
was set by the Oracle DBA. The setting in Oracle itself is what ultimately 
limits the # of concurrent connections.

Thanks,
Bruce

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Pascal Coulon
Sent: Tuesday, January 29, 2008 1:01 PM
To: mapguide-users@lists.osgeo.org
Subject: [mapguide-users] Oracle Max 10 Connections


Hi There,

We have a system based on MapGuide Enterprise, the Autodesk.Oracle provider
and an Oracle 10G R2. I have built a load test using Visual Studio 2008.
Every 5 seconds 60 new simultaneous users request a map.

I noticed that whatever the number of users, I still have a maximum of 10
active connections to the Oracle Instance. I believe that MapGuide must have
a pool of connections to Oracle; which are recycled regularly. The issue is
that if the number of users increases dramatically, the all system will be
badly slow. Can somebody advise on the maximum numbers of connection we can
hope with the Autodesk.Oracle provider. Can somebody also advise on a
possible tuning?

Any help would be appreciated.

regards,

Pascal
--
View this message in context: 
http://www.nabble.com/Oracle-Max-10-Connections-tp15169231s16610p15169231.html
Sent from the MapGuide Users mailing list archive at Nabble.com.

_______________________________________________
mapguide-users mailing list
mapguide-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users
_______________________________________________
mapguide-users mailing list
mapguide-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users

Reply via email to