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 [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users
