Tag Archives: JDBC connection

JDBC connection scripts for Oracle Applications R12

Comment

Last updated on May 31st, 2019 at 03:44 amThis article is part of EBS tutorials and provides different JDBC connection scripts for Oracle Applications R12 Oracle  OC4J connect to Oracle database using JDBC connection. Here is the list of some good scripts on JDBC connection The OC4J JVM process id can be found using the below opmnctl command opmnctl status -l A) To find total … Continue reading JDBC connection scripts for Oracle Applications R12 »

How to find the database session for JVM PID

Comment

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 »