Connection pooling in Oracle

[Eka Gautama]

Hi,

How can I implement connection pooling in Oracle? I used .NET Framework 1.0,
Oracle .NET Provider 1.0 and Oracle Database 9i

Thanks for the help...

Eka

 

[Mitesh Bilimoria]

This is exactly what you are looking for

http://msdn.microsoft.com/library/default.asp?
url=/library/en-
us/cpguide/html/cpconconnectionpoolingfornetdataproviderfor
oracle.asp

Microsoft article for connection pooling in Oracle.



Mitesh

 

[William \(Bill\) Vaughn]

It's on by default. ADO.NET providers are supposed to implement connection
pooling.
hth

--
____________________________________
Bill Vaughn
MVP, hRD
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

 

[Sushil Chordia]

Eka,
Connection pooling is implemented by default on MS Oracle .Net Provider. To
disable it you can set the pooling keyword in Connection String to false.
More on pooling keyword .
From docs, Pooling-When true, the connection is drawn from the appropriate
pool, or if necessary, created and added to the appropriate pool.
More Info at
http://msdn.microsoft.com/library/d...nectionpoolingfornetdataproviderfororacle.asp

Hope That Helps,
Sushil.