Oracle Connections with DataDirect Part 2: Reauthentication

In Part 1, we looked at fixing a problem with the memory usage of connection pools by accelerating the timeout, but that didn’t address some of the root problems.  For one, why does every user have his own connection pool?  DataDirect pools connections based on unique connection strings (as do most DB providers), but shouldn’t…


Oracle Connections with DataDirect Part 1: Timeout

Recently, a customer had issues with an ASP.Net application connecting to an Oracle database using the DataDirect provider.  The customer was seeing runaway memory usage and was using a 40 minute App Pool recycle schedule to combat it.  This worked for a while, but during App Pool recycles, they were seeing connection timeouts to the…