Re: DBCP monitoring tool

2005-05-09 Thread Remy Maucherat
On 5/9/05, Gabriel Belingueres <[EMAIL PROTECTED]> wrote: > Hi, > Are there any DBCP monitoring tool that allow me to monitor how many open > connections (and other stats) does DBCP holding? With Tomcat 5.5.4+, DBCP datasources should have an associated MBean, with all the us

Re: DBCP monitoring tool

2005-05-09 Thread Jimmy Ray
lect sid from v$session where program = 'JDBC Thin Client') order by b.name; To get open cursors: select * from v$open_cursor where sid in (select sid from v$session where program = 'JDBC Thin Client'); Regards, Jimmy Ray --- Gabriel Belingueres <[EMAIL PROTECTED]> w

DBCP monitoring tool

2005-05-09 Thread Gabriel Belingueres
Hi, Are there any DBCP monitoring tool that allow me to monitor how many open connections (and other stats) does DBCP holding? TIA, Gabriel