Connection Pooling in .NET

  • Thread starter Thread starter pradeep5511
  • Start date Start date
P

pradeep5511

I have two queries in connection pooling,

1) I have set 'pooling=true' in the connection string and I can see the
connection strings inside the pool in sql server. But how to see the
connection strings inside a pool in Oracle?

2) Where does this connection pooling resides, whether in aplication or
in the database?

Please note, I am using C#.
 
On 13 Dec 2006 21:42:08 -0800, (e-mail address removed) wrote:

¤ I have two queries in connection pooling,
¤
¤ 1) I have set 'pooling=true' in the connection string and I can see the
¤ connection strings inside the pool in sql server. But how to see the
¤ connection strings inside a pool in Oracle?
¤
¤ 2) Where does this connection pooling resides, whether in aplication or
¤ in the database?
¤
¤ Please note, I am using C#.

Connection pools are established at the application process or app pool level. I know you can use
'select * from v$session' to check connections from Oracle. You can also use the Windows Performance
Monitor (Perfmon).


Paul
~~~~
Microsoft MVP (Visual Basic)
 
Back
Top