Page 1 of 1

OracleConnection and recurring 'Commit'

Posted: Wed 03 Aug 2011 18:18
by vshiller
I noticed a "Commit" being sporadically executed in dbMonitor every 30 seconds or so even while my application is idle, is this being done to keep the OracleConnection open while the aspnet worker process is active or is there something in my application that is launching off commits?

here is the call stack:
DbMonitor.a
DbMonitor.OnCommit
OracleInternalConnection.Commit
cp.b
DbConnectionPoolGroup.a
DbConnectionPoolGroup.a
_TimerCallback.TimerCallback_Context
ExecutionContext.runTryCode
RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup
ExecutionContext.RunInternal
ExecutionContext.Run
_TimerCallback.PerformTimerCallback
aspnet_wp.exe

Any help would be appreciated.
--Victor

Posted: Thu 04 Aug 2011 10:44
by Shalex
Are you using connection pooling? Connection pool manager validates connections in pool every 30 seconds (approximately).
If this is not the case, please send us a small test project to reproduce the issue in our environment.

Posted: Thu 04 Aug 2011 15:44
by vshiller
We are using connection pooling, would it be issuing the commits?

Posted: Fri 05 Aug 2011 15:07
by Shalex
Yes, this is an activity of our connection pool manager.