OracleConnection and recurring 'Commit'

OracleConnection and recurring 'Commit'

Postby 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
vshiller
 
Posts: 2
Joined: Wed 03 Aug 2011 17:53

Postby 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.
Shalex
Devart Team
 
Posts: 7377
Joined: Thu 14 Aug 2008 12:44

Postby vshiller » Thu 04 Aug 2011 15:44

We are using connection pooling, would it be issuing the commits?
vshiller
 
Posts: 2
Joined: Wed 03 Aug 2011 17:53

Postby Shalex » Fri 05 Aug 2011 15:07

Yes, this is an activity of our connection pool manager.
Shalex
Devart Team
 
Posts: 7377
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle