My Oracle Support Banner

JDBC Connection Keep Growing With Majority of Connections Being Inactive (Doc ID 311933.1)

Last updated on AUGUST 11, 2024

Applies to:

Oracle E-Business Suite Technology Stack - Version 11.5.10.2 to 11.5.10.2 [Release 11.5.10]
Information in this document applies to any platform.
This problem can occur on any platform.
 

Symptoms

Whilst monitoring the database connections, you observe that inactive JDBC Connections keeps on growing and are not getting dropped.  You could use the SQL below to monitor these connections

REM SQL to check number of JDBC connections

set echo on
set feedback on
set pagesize 132
set linesize 80
col username format a10
col how_many format 9999
col machine format a25

select s.machine, s.username, s.module, count(*) how_many
from (select distinct PROGRAM, PADDR, machine, username, module from V$SESSION) s,
 v$process p
where s.paddr = p.addr and s.program = 'JDBC Thin Client'
group by s.machine,s.username, s.module;

REM end of SQL

This eventually results in your database running out of connections or other resources such as memory.

NOTE - it is quite normal for JDBC connections to show as INACTIVE status.  This in itself does not mean there is a problem.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.