My Oracle Support Banner

Java Application Is Slow With 11.1.x JDBC Thin Driver And Accumulates Memory (Doc ID 1996449.1)

Last updated on AUGUST 01, 2019

Applies to:

JDBC - Version 11.1.0.7 and later
Information in this document applies to any platform.

Symptoms

This is a java application running on HP-UX, using a 11.1.0.7 client in order to connect to a 11.2.0.3 database.
After some time executing, the application slows down. Client java processes show a high memory usage.

Observations
---------------
1. No application server is being used.
2. The issue is consistent.
3. The issue has always existed.
4. Just this java process is affected.

Analysis of .hprof by Eclipse Memory Analysis tool

Problem Suspect 1
-------------------------
One instance of "oracle.jdbc.pool.OracleImplicitConnectionCache" loaded by "sun.misc.Launcher$AppClassLoader @ 0x2b5ec490" occupies 421,491,000 (58.46%) bytes. The memory is accumulated in one instance of "java.lang.Object[]" loaded by "<system class loader>".

Keywords
sun.misc.Launcher$AppClassLoader @ 0x2b5ec490
java.lang.Object[]
oracle.jdbc.pool.OracleImplicitConnectionCache


Problem Suspect 2
---------------------------
10 instances of "oracle.jdbc.driver.T4CConnection", loaded by "sun.misc.Launcher$AppClassLoader @ 0x2b5ec490" occupy 170,896,560 (23.70%) bytes.

Biggest instances:
•oracle.jdbc.driver.T4CConnection @ 0x2b6d7920 - 35,773,680 (4.96%) bytes.
•oracle.jdbc.driver.T4CConnection @ 0x2bd62b28 - 35,764,864 (4.96%) bytes.
•oracle.jdbc.driver.T4CConnection @ 0x2b6ee108 - 35,757,016 (4.96%) bytes.
•oracle.jdbc.driver.T4CConnection @ 0x2bde5048 - 31,783,608 (4.41%) bytes.
•oracle.jdbc.driver.T4CConnection @ 0x2b6728c0 - 31,739,112 (4.40%) bytes.

Keywords
sun.misc.Launcher$AppClassLoader @ 0x2b5ec490
oracle.jdbc.driver.T4CConnection



Problem Suspect 3
---------------------------
3 instances of "oracle.jdbc.driver.LRUStatementCache", loaded by "sun.misc.Launcher$AppClassLoader @ 0x2b5ec490" occupy 94,869,632 (13.16%) bytes.

Biggest instances:
•oracle.jdbc.driver.LRUStatementCache @ 0x2b700188 - 31,702,576 (4.40%) bytes.
•oracle.jdbc.driver.LRUStatementCache @ 0x2be2df28 - 31,689,648 (4.40%) bytes.
•oracle.jdbc.driver.LRUStatementCache @ 0x2c571888 - 31,477,408 (4.37%) bytes.

Keywords
sun.misc.Launcher$AppClassLoader @ 0x2b5ec490
oracle.jdbc.driver.LRUStatementCache


Changes

 

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
Changes
Cause
Solution


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