OracleConnection and recurring 'Commit'

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
vshiller
Posts: 2
Joined: Wed 03 Aug 2011 17:53

OracleConnection and recurring 'Commit'

Post by vshiller » Wed 03 Aug 2011 18:18

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

Shalex
Site Admin
Posts: 8247
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Thu 04 Aug 2011 10:44

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.

vshiller
Posts: 2
Joined: Wed 03 Aug 2011 17:53

Post by vshiller » Thu 04 Aug 2011 15:44

We are using connection pooling, would it be issuing the commits?

Shalex
Site Admin
Posts: 8247
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Fri 05 Aug 2011 15:07

Yes, this is an activity of our connection pool manager.

Post Reply