My Oracle Support Banner

Waits On "Dbms_Ldap: Ldap Operation" Causing High Load On The System (Doc ID 948905.1)

Last updated on JANUARY 10, 2019

Applies to:

Oracle Internet Directory - Version 10.1.2 and later
Information in this document applies to any platform.

Symptoms

Oracle Application Server (AS) with Portal, Oracle Internet Directory (OID), and other products.

Waits on dbms_ldap: ldap operation are causing high load on the system.

The problem comes from the Metadata Repository Database that serves as the Infrastructure database.

A custom procedure seems to be the culprit, and is initiating a call by a user such as PORTAL_PUBLIC. This procedure seems stuck on the "DBMS_LDAP: LDAP Operation" while holding a lock on a table (this revealed by an RDBMS stack trace).

Nothing has changed other than an existing custom application started to be used more often. Spikes on the load are usually preceded by holding a lock on 'LDAP Operation' and waiting locks on the table.

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
References

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