[mapguide-users] Oracle Max 10 Connections

Zac Spitzer zac.spitzer at gmail.com
Wed Jan 30 08:13:22 EST 2008


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 <pascal.coulon at atkinsglobal.com>
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: 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
> > _______________________________________________
> > mapguide-users mailing list
> > mapguide-users at lists.osgeo.org
> > 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
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>



-- 
Zac Spitzer -
http://zacster.blogspot.com (My Blog)
+61 405 847 168
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20080131/f6bfe4e8/attachment.html


More information about the mapguide-users mailing list