Closing Connections using ODP .NET

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
Imayakumar said:
hi,

I am using ODP .NET to connect to Oracle database. I have about 3000 users
Click to expand...
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..
 
Back
Top