Database idle session for module JDBC Thin Client
We have detected a high quantity of database sessions of module JDBC Thin Client in idle status.
Oracle EBS version: 11.5.9
Oracle Database version: 9.2.0.8.0
Please see the output of monitor_jdbc_conn.sql script (monitor_jdbc_conn.sql - Script to monitor JDBC connections in Apps eBusiness Suite (Doc ID 557194.1)):
=======================================================
JDBC Connections
TIME
-----------------
01-aug-2014 09:32
=======================================================
=======================================================
No of Instances
INSTANCE_ID COUNT(*)
----------- ----------
1 710
=======================================================
JDBC Connection Usage Per JVM Process
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Machine Name Process ID COUNT(*)
------------------------- ---------- ----------
calafquen 1234 2
calbuco 17916 162
calbuco 17918 8
calbuco 174
isluga.vtr.cl 1234 1
maullin 1234 2
sankuru.vtr.cl 1234 3
tobol.vtr.cl 1234 3
8 rows selected.
Connection Usage Per Module