[mapguide-users] Oracle Max 10 Connections

[Bruce Dechant]

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: mapguide-users-bounces at lists.osgeo.org [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Pascal Coulon
Sent: Tuesday, January 29, 2008 1:01 PM
To: mapguide-users at 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 at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users