How to find the database session for JVM PID
To 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) …
How to find the database session for JVM PID Read More »