[mapguide-users] Oracle Max 10 Connections

Brad Nesom kidsmake6 at msn.com
Wed Jan 30 10:29:06 EST 2008


Is it this?

http://weblogs.asp.net/ngur/archive/2004/01/21/61207.aspx

-----Original Message-----
From: mapguide-users-bounces at lists.osgeo.org
[mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Pascal Coulon
Sent: Wednesday, January 30, 2008 8:12 AM
To: mapguide-users at lists.osgeo.org
Subject: Re: [mapguide-users] Oracle Max 10 Connections


Hi there,

I am using Windows Server 2003 stantard edition. I do not think I am limited
to 10 connections. Don't I? Any idea, how I can determine the maximum number
of connections? 

Regards,


zspitzer wrote:
> 
> 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.ht
ml
>> > 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.ht
ml
>> 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
> 
> _______________________________________________
> 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-tp15169231s16610p15182894.ht
ml
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



More information about the mapguide-users mailing list