This 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 […]
JDBC connection
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) […]