[mapguide-users] Having issues with too many inactive FDO connections to Oracle

[Zac Spitzer]

please always state the versions of all the software being used


On Tue, Feb 12, 2013 at 9:47 AM, SteveS <steve.calpoly at gmail.com> wrote:

> I'm having issues with mapguide creating and leaving open too many sessions
> in Oracle. Our maps have approximately 5-10 Oracle layers and the web app
> gets about 100 sessions created a day. For the most part the number of open
> database connections hangs around 10-30, but it will occasionally spike up
> into the hundreds, and it seems even after the sessions have been killed
> many inactive connections are left open.
>
> Here is my serverconfig.ini settings:
> ----------------------------------
>
> DataTransactionTimerInterval = 120
> DataTransactionTimeout = 360
> JoinQueryBatchSize = 1000
> DataConnectionTimerInterval = 120
> DataConnectionTimeout = 360
> DataConnectionPoolSizeCustom = OSGeo.Gdal:1
> DataConnectionPoolSize = 100
> DataConnectionPoolExcludedProviders = OSGeo.SDF,OSGeo.SHP
> DataConnectionPoolEnabled = 1
> DataCacheSize = 100
> CacheTimerInterval = 3600
> CacheTimeLimit = 86400
> CacheSize = 100
>
> I've got the connection pool set to 100 but the server will still go over
> it. One thing to note is that the same user may change maps numerous times
> in one visit. Instead of creating a new session i generally save the
> session
> ID and overwrite the data in the session repository. Could this be the
> cause
> of my issue? Also, how do my server settings look?
>
>
>
> --
> View this message in context:
> http://osgeo-org.1560.n6.nabble.com/Having-issues-with-too-many-inactive-FDO-connections-to-Oracle-tp5033572.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
Solution Architect / Director
Ennoble Consultancy Australia
+61 405 847 168
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapguide-users/attachments/20130212/ebe03517/attachment.html>