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

Last updated on APRIL 06, 2015

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


Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms