Waits On "Dbms_Ldap: Ldap Operation" Causing High Load On The System
Last updated on OCTOBER 20, 2017
Applies to:Oracle Internet Directory - Version 10.1.2 and later
Information in this document applies to any platform.
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.
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