Database Versions 10.2.0.x DBMS_LDAP Calls Consume High CPU Resource

(Doc ID 811609.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Internet Directory - Version 10.1.4.3 to 10.1.4.3 [Release 10gR3]
Information in this document applies to any platform.

Symptoms


The problem has been reported on multiple scenarios like


In all the cases, the database version was 10.2.0.x

An example stack trace given below shows a session which is waiting for 'DBMS_LDAP:LDAP operation'  which uses high CPU resource.

 

 

SO: c00000013c760780, type: 4, owner: c00000013da70fc8, flag: INIT/-/-/0x00
(session) sid: 2021 trans: c00000013aeac710, creator: c00000013da70fc8, flag: (8000041) USR/-
BSY/-/-/-/-/-
DID: 0001-0233-000002A2, short-term DID: 0001-0233-000002A3
txn branch: 0000000000000000
oct: 47, prv: 0, sql: c0000000e81ad728, psql: c00000013e2c12f0, user: 0/SYS
O/S info: user: applprod, term: unknown, ospid: 29890, machine: <machine_name>
program: JDBC Thin Client
client info: 82 0
application name: fnd.preferences.server.PreferencesAM, hash value=173592914
action name: 29890, hash value=889299756
waiting for 'DBMS_LDAP: LDAP operation ' blocking sess=0x0000000000000000 seq=13824
wait_time=0 seconds since wait started=2229

 

 

Changes

 

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