out of interest what platform are you running on? XP has the stupid limit of 10 tcp connections<br><br><a href="http://www.lvllord.de/">http://www.lvllord.de/</a> has a patcher which increases this limit<br><br><div class="gmail_quote">
On Jan 30, 2008 11:01 PM, Pascal Coulon <<a href="mailto:pascal.coulon@atkinsglobal.com">pascal.coulon@atkinsglobal.com</a>> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br>Thank you very much for your reply. I have increased the number of<br>connections for autodesk.oracle to higher level. Unfortunatelly, whatever<br>the number of users (e.g. 60 users), I only got a maximum of 11 conenctions.<br>
We are confident that oracle is properly set-up with a maximum amount of<br>session of 100. While executing the test, I had a total of 36 sessions.<br><br>Do you have reference on the maximum number of conenctions available in the<br>
pool? Is there a maximum connection value which overides the configuration<br>parameters?<br><br>Regards,<br><br>Pascal<br><div><div></div><div class="Wj3C7c"><br><br>Bruce Dechant wrote:<br>><br>> The connection limit for specific providers is specified in the<br>
> serverconfig.ini file.<br>> Please check this setting:<br>><br>> DataConnectionPoolSizeCustom<br>><br>> Example of the above:<br>> DataConnectionPoolSizeCustom = Autodesk.Oracle:10<br>><br>> If the above setting is not limiting the # of Oracle connections then the<br>
> connection limit is controlled at the Oracle DB side.<br>><br>> Note: Changing the setting in the serverconfig.ini file DOES NOT override<br>> what was set by the Oracle DBA. The setting in Oracle itself is what<br>
> ultimately limits the # of concurrent connections.<br>><br>> Thanks,<br>> Bruce<br>><br>> -----Original Message-----<br>> From: <a href="mailto:mapguide-users-bounces@lists.osgeo.org">mapguide-users-bounces@lists.osgeo.org</a><br>
> [mailto:<a href="mailto:mapguide-users-bounces@lists.osgeo.org">mapguide-users-bounces@lists.osgeo.org</a>] On Behalf Of Pascal Coulon<br>> Sent: Tuesday, January 29, 2008 1:01 PM<br>> To: <a href="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</a><br>
> Subject: [mapguide-users] Oracle Max 10 Connections<br>><br>><br>> Hi There,<br>><br>> We have a system based on MapGuide Enterprise, the Autodesk.Oracle<br>> provider<br>> and an Oracle 10G R2. I have built a load test using Visual Studio 2008.<br>
> Every 5 seconds 60 new simultaneous users request a map.<br>><br>> I noticed that whatever the number of users, I still have a maximum of 10<br>> active connections to the Oracle Instance. I believe that MapGuide must<br>
> have<br>> a pool of connections to Oracle; which are recycled regularly. The issue<br>> is<br>> that if the number of users increases dramatically, the all system will be<br>> badly slow. Can somebody advise on the maximum numbers of connection we<br>
> can<br>> hope with the Autodesk.Oracle provider. Can somebody also advise on a<br>> possible tuning?<br>><br>> Any help would be appreciated.<br>><br>> regards,<br>><br>> Pascal<br>> --<br>
> View this message in context:<br>> <a href="http://www.nabble.com/Oracle-Max-10-Connections-tp15169231s16610p15169231.html" target="_blank">http://www.nabble.com/Oracle-Max-10-Connections-tp15169231s16610p15169231.html</a><br>
> Sent from the MapGuide Users mailing list archive at <a href="http://Nabble.com" target="_blank">Nabble.com</a>.<br>><br>> _______________________________________________<br>> mapguide-users mailing list<br>
> <a href="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</a><br>> <a href="http://lists.osgeo.org/mailman/listinfo/mapguide-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapguide-users</a><br>
> _______________________________________________<br>> mapguide-users mailing list<br>> <a href="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</a><br>> <a href="http://lists.osgeo.org/mailman/listinfo/mapguide-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapguide-users</a><br>
><br>><br><br></div></div><font color="#888888">--<br>View this message in context: <a href="http://www.nabble.com/Oracle-Max-10-Connections-tp15169231s16610p15180738.html" target="_blank">http://www.nabble.com/Oracle-Max-10-Connections-tp15169231s16610p15180738.html</a><br>
</font><div><div></div><div class="Wj3C7c">Sent from the MapGuide Users mailing list archive at <a href="http://Nabble.com" target="_blank">Nabble.com</a>.<br><br>_______________________________________________<br>mapguide-users mailing list<br>
<a href="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</a><br><a href="http://lists.osgeo.org/mailman/listinfo/mapguide-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapguide-users</a><br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br>Zac Spitzer -<br><a href="http://zacster.blogspot.com">http://zacster.blogspot.com</a> (My Blog)<br>+61 405 847 168