Session Number Increase

ekarasu · Post by **ekarasu** » Thu 29 Jun 2006 07:22

Hi,
Although we close the connections that are opened within our application, the session number of Oracle increases by time.

While connecting to oracle we use the syntax below

ConnectionString = "Server=X; uid = A; Password =X; Connection Lifetime=0";

Does this occur because of our ConnectionString?

We use Oracle Express 10g.

Alexey · Post by **Alexey** » Thu 29 Jun 2006 09:49

Probably it is because of Connection Pooling feature. If you familiar with it please describe here what exactly is the problem.

ekarasu · Post by **ekarasu** » Thu 29 Jun 2006 20:39

No, I am not familiar with it.

Alexey · Post by **Alexey** » Fri 30 Jun 2006 10:41

Please describe what exactly you need or what is the problem then.

CrescentFire · Post by **CrescentFire** » Wed 26 Jul 2006 05:55

Hi,
We experience the same problem. Although we close connection in the application, the connection lives till application terminates.

Alexey · Post by **Alexey** » Wed 26 Jul 2006 08:25

It is because of Connection Pooling feature. For more information please read the FAQ of OraDirect .NET help documentation.