DIP Performance Issues - Sync of New Entries Takes 30 Minutes (Doc ID 1956313.1)

Last updated on AUGUST 30, 2023

Applies to:

Symptoms

Syncing changes from source ldap takes a long time. (as long as 30 minutes)

Logs showing long searchtimes

Example entry in wls_ods1-diagnostic.log

>>> wls_ods1-diagnostic-xxx.log:[2014-10-22T10:16:52.043-07:00] [wls_ods1] [NOTIFICATION] [DIP-10176] [oracle.dip.XXXX] [tid: XXXXX] [userId:<WLS_ADMIN>] [ecid: <ECID>] [APP: DIP#11.1.1.2.0] CHGLOGFILTER (&(changenumber>=10067270)(changenumber<=10067769)((!(changeType=DELETE))))

>>> wls_ods1-diagnostic-xxx.log:[2014-10-22T10:16:52.085-07:00] [wls_ods1] [NOTIFICATION] [] [oracle.dip.XXXX] [tid: oracle.ldap.odip.web.DIPSyncWriterThread] [userId:<WLS_ADMIN>] [ecid: <ECID>] [APP: DIP#11.1.1.2.0] Modification of Entry Successful: uid=<UID>,ou=people,o=<DOMAIN> ChangeNumber: 10067267

>>> wls_ods1-diagnostic.log:[2014-10-22T10:46:44.079-07:00] [wls_ods1] [TRACE] [] [oracle.dip.XXXX] [tid: XXXX] [userId:<WLS_ADMIN>] [ecid: <ECID>] [APP: DIP#11.1.1.2.0] [SRC_CLASS: oracle.ldap.odip.gsi.LDAPReader] [SRC_METHOD: searchChanges] Search Time 1792036

Notice "Search Time 1792036"  (this is a very large search time)

Attempting the same search at command line seems to hang or take a very long time to return.

example: time ldapsearch -h <SUN_LDAP_HOSTNAME> -p <PORT> -D "<SUN_LDAP_ADMIN_USER>" -w <PASSWORD> -b "ou=people,o=<DOMAIN>" -s sub "(&(changenumber>=10067270)(changenumber<=10067769)((!(changeType=DELETE))))"

Cause

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