out of interest what platform are you running on? XP has the stupid limit of 10 tcp connections
http://www.lvllord.de/ has a patcher which increases this limit On Jan 30, 2008 11:01 PM, Pascal Coulon <[EMAIL PROTECTED]> wrote: > > 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 > -- Zac Spitzer - http://zacster.blogspot.com (My Blog) +61 405 847 168
_______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users
