Oracle Connection Pooling

[Jim Heavey]

Hello, I am trying to figure out connection pooling. I found this article
which discussed the various options available on the connection string,
unfortunately it was for the "oracle" provider and not the "Microsoft
Oracle provider". Where can I find the options which are avialable for the
Microsoft Version?

How do I control the number of Connection which are in the pool? I placed
this in my connection string "Min Pool Size=30" and it did not bark at me,
but then again, I am not sure that it really opened 30 connections? How
can I see how man connections are open for my application?

I think I am opening connections and not closing them because after a while
my application begins to have problems making a connection. Someone
indicated that I should create "performance counters" to monitor how many
connections are open at any one time. I have never set up performance
counters. Does someon how a sample?

Thanks in advance for your assistance!!!!!

 

[Sahil Malik]

You can find all the details at

ms-help://MS.MSDNQTR.2003JUL.1033/cpref/html/frlrfSystemDataSqlClientSqlConn
ectionClassConnectionStringTopic.htm

How many connections it actually opens is something that is under the covers
for the most part. It opens more, as it needs more, and you can specify an
upper limit. You can check how many active connections are currently open
thru enterprise manager.

I don't see how performance counters will help in this, though I donot know
the exact logic of your app either. You can see performance counters in
control panel -> administrative tools -> performance, and you can play with
it using the "System.Diagnostics.PerformanceCounter" class.

- Sahil Malik
Independent Consultant
You can reach me thru my blog at -
http://www.dotnetjunkies.com/weblog/sahilmalik/

 

[Paul Clement]

¤ Hello, I am trying to figure out connection pooling. I found this article
¤ which discussed the various options available on the connection string,
¤ unfortunately it was for the "oracle" provider and not the "Microsoft
¤ Oracle provider". Where can I find the options which are avialable for the
¤ Microsoft Version?
¤
¤ How do I control the number of Connection which are in the pool? I placed
¤ this in my connection string "Min Pool Size=30" and it did not bark at me,
¤ but then again, I am not sure that it really opened 30 connections? How
¤ can I see how man connections are open for my application?

If you are using Microsoft's .NET provider for Oracle then Min Pool Size is the correct parameter.
However, I don't think I would recommend using it unless there are times when your application will
need this many connections over a short period of time. It's an inefficient use of database
resources

Connection Pooling for the .NET Framework Data Provider for Oracle
http://msdn.microsoft.com/library/d...nectionpoolingfornetdataproviderfororacle.asp

You should be able to use Oracle's Enterprise Manager to monitor connections.


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)