I usually do this at the database level. I can give
you an example of the SQL that we run to see how many
connections as well as cursors are being used by our
Thin JDBC clients to Oracle:
To get sessions/connections to oracle:
select sid,username,program from v$session
where program = 'JDBC Thin Client';
To get cursors information:
select b.name,a.*
from v$sesstat a,v$statname b
where a.statistic# = b.statistic#
and b.name in ('opened cursors current','opened
cursors cumulative',
'session uga memory','session pga memory')
and a.sid in (select 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]> wrote:
> Hi,
> Are there any DBCP monitoring tool that allow me to
> monitor how many open
> connections (and other stats) does DBCP holding?
> TIA,
> Gabriel
>
Yahoo! Mail
Stay connected, organized, and protected. Take the tour:
http://tour.mail.yahoo.com/mailtour.html
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
