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

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

Using Oracle Application Server (AS) with Portal, 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

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