Page 1 of 1

Session Number Increase

Posted: Thu 29 Jun 2006 07:22
by ekarasu
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.

Posted: Thu 29 Jun 2006 09:49
by Alexey
Probably it is because of Connection Pooling feature. If you familiar with it please describe here what exactly is the problem.

Posted: Thu 29 Jun 2006 20:39
by ekarasu
No, I am not familiar with it.

Posted: Fri 30 Jun 2006 10:41
by Alexey
Please describe what exactly you need or what is the problem then.

Posted: Wed 26 Jul 2006 05:55
by CrescentFire
Hi,
We experience the same problem. Although we close connection in the application, the connection lives till application terminates.

Posted: Wed 26 Jul 2006 08:25
by Alexey
It is because of Connection Pooling feature. For more information please read the FAQ of OraDirect .NET help documentation.