Thank you very much for your reply. I have increased the number of connections for autodesk.oracle to higher level. Unfortunatelly, whatever the number of users (e.g. 60 users), I only got a maximum of 11 conenctions. We are confident that oracle is properly set-up with a maximum amount of session of 100. While executing the test, I had a total of 36 sessions.
Do you have reference on the maximum number of conenctions available in the pool? Is there a maximum connection value which overides the configuration parameters? Regards, Pascal Bruce Dechant wrote: > > 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: [email protected] > 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 > [email protected] > http://lists.osgeo.org/mailman/listinfo/mapguide-users > _______________________________________________ > mapguide-users mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/mapguide-users > > -- View this message in context: http://www.nabble.com/Oracle-Max-10-Connections-tp15169231s16610p15180738.html Sent from the MapGuide Users mailing list archive at Nabble.com. _______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users
