please always state the versions of all the software being used
On Tue, Feb 12, 2013 at 9:47 AM, SteveS <[email protected]> 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 > [email protected] > http://lists.osgeo.org/mailman/listinfo/mapguide-users > -- Zac Spitzer Solution Architect / Director Ennoble Consultancy Australia +61 405 847 168
_______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users
