Connection Pooling in .NET

[pradeep5511@gmail.com]

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#.

[Paul Clement]

Re: Connection Pooling in .NET

On 13 Dec 2006 21:42:08 -0800, pradeep5511@gma il.com 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)