Closing Connections using ODP .NET

[Guest]

hi

I am using ODP .NET to connect to Oracle database. I have about 3000 users concurrently accessing the application. In the Code i am exclusively closing the connection and disposing the object. But sometimes, over 100 connections left unclosed and they all stay in 'INACTIVE' mode. I found this using TOAD. Why is this happening? Do i have to do something else for things to work properly? Please give me suggestions.

Thanks

-Imayakuma

 

[Miha Markic [MVP C#]]

Hi,

This is a feature of connection pooling.
Closing a connection instance doesn't mean releasing (depends on the pooling
settings) physical connection.
See
Connection Pooling for the .NET Framework Data Provider for Oracle
..net help topic.
You might turn off pooling - you'll get rid of database connections, but
you'll experience delays when accessing data.

--
Miha Markic [MVP C#] - RightHand .NET consulting & software development
miha at rthand com
www.rthand.com

hi,

I am using ODP .NET to connect to Oracle database. I have about 3000 users

concurrently accessing the application. In the Code i am exclusively closing
the connection and disposing the object. But sometimes, over 100 connections
left unclosed and they all stay in 'INACTIVE' mode. I found this using TOAD.
Why is this happening? Do i have to do something else for things to work
properly? Please give me suggestions..