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

Last updated on MARCH 08, 2017

Applies to:

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

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-780.log:[2014-10-22T10:16:52.043-07:00] [wls_ods1] [NOTIFICATION] [DIP-10176] [oracle.dip.lookup_person] [tid: lookup_person] [userId: weblogic] [ecid: 2f0e5ecee1922ca8:734cd41:147f4b98173:-8000-00000000000a8549,0] [APP: DIP#11.1.1.2.0] CHGLOGFILTER (&(changenumber>=10067270)(changenumber<=10067769)((!(changeType=DELETE))))
>>> wls_ods1-diagnostic-780.log:[2014-10-22T10:16:52.085-07:00] [wls_ods1] [NOTIFICATION] [] [oracle.dip.lookup_person] [tid: oracle.ldap.odip.web.DIPSyncWriterThread] [userId: weblogic] [ecid: 2f0e5ecee1922ca8:734cd41:147f4b98173:-8000-00000000000a8549,1:173696] [APP: DIP#11.1.1.2.0] Modification of Entry Successful: uid=74496979,ou=people,o=oracle ChangeNumber: 10067267
>>> wls_ods1-diagnostic.log:[2014-10-22T10:46:44.079-07:00] [wls_ods1] [TRACE] [] [oracle.dip.lookup_person] [tid: lookup_person] [userId: weblogic] [ecid: 2f0e5ecee1922ca8:734cd41:147f4b98173:-8000-00000000000a8549,0] [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 Sunone.oracle.com -p 389 -D "cn=directory manager" -w %pwd -b "ou=people,o=oracle" -s sub "(&(changenumber>=10067270)(changenumber<=10067769)((!(changeType=DELETE))))"

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