Re: How to monitor JDBC connections?

From: Pascal Byrne <byrne_at_nospam.net>
Date: Thu, 27 Jun 2002 19:29:15 +0200
Message-ID: <3D1B4B6B.90301@nospam.net>

> Does this mean that the db has been hitting more than 75 simultaneous
> connections by our application?

Oracle itself will have some open connections (8 in my setup)

A list of open connections can be seen in SQL*Plus by:

   select  s.username, s.status,  s.sid,     s.serial#,
   p.spid,     s.machine, s.process, s.lockwait
   from    v$session s, v$process p
   where     s.paddr    = p.addr;

A word of advice. Don't put connection.close() statements in finalize(). There is no guarantee that finalize will run in a timely manner or even run at all!

>
> Is there a better way to monitor the JDBC connections?
>
> Regards,
> Peter
Received on Thu Jun 27 2002 - 12:29:15 CDT