Oracle Simultaneous Sessions Problem

  • Thread starter Thread starter pmclinn
  • Start date Start date
P

pmclinn

I have created a aspx page that requires me to pull data from multiple
tables in an Oracle DB. The data is pulled down and then stored in
local variables, and then closed and disposed. I have implimented an
error handling to prevent sessions from remaining open and yet I'm
still noticing that sessions to the oracle db are remaining open.

I cannot figure out what is going on. I have gone proceedure to
proceedure looking for poorly terminated connections. Has any one else
experienced this issue?

-Peter
 
I experienced a similar problem recently. It turned out that when
making return trips to the DB that the connection I was using came from
an Oracle connection pool rather than a new connection. In my case, it
seemed like the connection maintained some stateful characteristics
that caused me a lot of grief. Here is how I got around it using the
oracle data provider for .NET.

strCon="user id=<USERID>;data
source=<DATABASE>;password=<PASSWORD>;pooling=false"

Hope this helps.

Corey
 
Back
Top