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, pradeep5***@gmail.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)

Updating database in a loop
System.Threading.Timer does not tick
There is already an open DataReader associated with this Connection which must be closed first
Q: DataColumn Expressions
Looping through all Tables in a Database
Aaron - You're becoming famous!
control array
Datagrid problem
Q: DataView with Table with large number of rows
Getting an Object Properties value...