Oracle Connection Pool !

[Tim Smith]

If I monitor v$session I can see a lot of sessions being created and
destroyed. The application is .Net 1.0 using OLEDB and should have a
connection pool that enables reuse of existing connections.

However IS it possible to maintain a minimum number of connections so
that it reuses them?? I see in Google people say the min pool size is
ignored.

We are starting to regret using the connection pooling feature since
it is creating a new Oracle session frequently which is a very
expensive operation.

Is there anything we can do to maintain a constant/min number of
connections with the given software?

 

[Paul Clement]

On 25 Mar 2004 07:52:07 -0800, (e-mail address removed) (Tim Smith) wrote:

¤ If I monitor v$session I can see a lot of sessions being created and
¤ destroyed. The application is .Net 1.0 using OLEDB and should have a
¤ connection pool that enables reuse of existing connections.
¤
¤ However IS it possible to maintain a minimum number of connections so
¤ that it reuses them?? I see in Google people say the min pool size is
¤ ignored.
¤
¤ We are starting to regret using the connection pooling feature since
¤ it is creating a new Oracle session frequently which is a very
¤ expensive operation.
¤
¤ Is there anything we can do to maintain a constant/min number of
¤ connections with the given software?

You don't mention what kind of application you are working with (web? desktop?) but the answer is
likely no.

The benefit of connection pooling is realized when you have a single client or multiple clients
requesting and releasing connections through the same process either concurrently or within the same
limited time frame (idle connection lifetime).

Connection pooling is enabled in the provider by default. There shouldn't be any impact with respect
to Oracle sessions even if you were to turn it off.


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

 

[Guest]

I have noticed this too when using crystal reports within VS.NE

It seems like every report holds a connection even after it is completed

Crystal blames it on the microsoft ado.net

I tried to turn pooling off, but a orclae session is still held after the report is completed and it doesn't timeout either

..Net sdk 1.
Oracle 8.1.6