Home » JDBC connection

JDBC connection

JDBC connection scripts for Oracle Applications R12

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 scripts for Oracle Applications R12 Read More »

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 »

Scroll to Top