Monitor connection pool - ODP.Net 10g

[Het2109]

I am using odp.net 10gR2. Is there a way I can monitor the connection pool, like action connection, connection strings or active connections etc. Also, can I know the like how many connection pools will be there per cpu in my server and can I make any of the connection pool as inactive or disable or something like that ? Thanks in advance.

Het Waghela :)Be Humble in Victory and Strong in Defeat.:) Het Waghela, Blog|Het Waghela DotNet Questions Link|More Links

[Wendelius]

Hi, You should be able to monitor connection pool (and also many other things) using Performance Monitor (open from COntrol Panel). ODP installation adds several new counters and groups by default. Hope this helps, Mika

[Het2109]

Performance Monitor integration is available in 11g and not in 10g :(. Still, thanks and lemme have another look at that one.

Het Waghela :)Be Humble in Victory and Strong in Defeat.:) Het Waghela, Blog|Het Waghela DotNet Questions Link|More Links

[Wendelius]

Sorry, you're absolutely right :doh: . It comes in 11g. Some of the things you asked could be found out from server side. If you have a connection in your connection pool you can see it from v$-views at server. You can also separate which connections are active and running a command and which are only waiting. In connection string you can define the maximum amount of simultaneous connections and how long they are kept in connection pool and is the connection pooling used at all. This wasn't exactly what you we're asking but might help you to get forward. Mika

[Het2109]

Thanks Mika, Actually I tried v$session but I am not able to figure out through which application user has logged in, and got into that connection pool. Also, its like after some number of connections (less then 20) it is not allowing me to log in and its just spinning and not giving error and I have closed all the other connection from other browsers. So practically there are no active connection, still its not letting me in. SELECT sid, serial#, event, seconds_in_wait, client_info, status, terminal FROM V$SESSION WHERE PROGRAM IS NOT NULL and OSUSER = 'ASPNET' and terminal = 'Terminal1' order by seconds_in_wait Anyways, lemme try some other things, if I can think of ! Thanks for your help Mika.

Het Waghela :)Be Humble in Victory and Strong in Defeat.:) Het Waghela, Blog|Het Waghela DotNet Questions Link|More Links

[Wendelius]

You're welcome :) Mika