Tag Archives: JDBC connection

How to find the database session for JVM PID

Last updated on July 29th, 2016 at 06:26 amTo find total number of open database connections for a given JVM PIDSELECT s.process, Count(*) all_count FROM   gv$session s WHERE s.process IN () GROUP BY  s.process To find number of database connections per JVM that were inactive for longer then 60 minutes SELECT s.process, Count(*) olderConnection_count FROM   gv$session s WHERE  s.process IN () and  s.last_call_et>=(60*60) and s.status=’INACTIVE’ … Continue reading How to find the database session for JVM PID »

JDBC connection scripts

Last updated on November 28th, 2015 at 12:34 pmOracle  OC4J connect to database using JDBC connection. Here is the list of some good scripts on JDBC connection A) To find total number of open database connections for a given JVM PID SELECT s.process, Count(*) all_count FROM v$session s WHERE s.process IN () GROUP BY s.process B) To find number of database connections per JVM that were … Continue reading JDBC connection scripts »