Re: I want to test if connection pool is working...

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Fri, 19 Jan 2007 03:09:24 GMT
Message-ID: <Xns98BCC2DF1834Danacedenthotmailcom@69.28.173.184>

"Shinya Koizumi" <s_at_k.com> wrote in
news:wYIrh.161674$YV4.86226_at_edtnps89:

> How can I make sure when using the connection pool( see the link below
> ) and closing the logical connection, I am not actually cutting the
> phygical connectoin? Is there any way to monitor the connection from
> perticular computer( Application Server) in oracle?
>
> http://www.lc.leidenuniv.nl/awcourse/oracle/java.920/a96654/connpoca.ht
> m#1057365
>
>
>

select osuser, username, machine from v$session; Received on Thu Jan 18 2007 - 21:09:24 CST