Hmm, I seem to have a connection pooling problem.
System.Data.OracleClient is supposed to have connection pooling built in. The idea is that if you use exactly the same connection string, it will reuse a connection from the pool. However in practise we seem to end up with loads of duplicate sessions, all inactive, sitting on the database. This web application isn't even accessible outside our development office, but already we are running out of sessions.
I've searched long and hard for a solution, but so far have turned up nothing. I thought it was time to ask if anyone else has encountered this problem? And if so, did you solve it and how?