OID 11g: Performance Issue With Paged Ldapsearch Query to OID when Compared to Non-paged Ldapsearch. (Doc ID 2341813.1)

Last updated on SEPTEMBER 17, 2019

Applies to:

Symptoms

On : 11.1.1.9.0 version, OID LDAP Server

+. One of the paged LDAPSEARCH query to Oracle Internet Directory (OID) is slow and taking around 45 sec to bring back the result.

time ldapsearch -h <OID_HOSTNAME> -p <PORT> -D cn=orcladmin -q -b "uid=<UID>,ou=Users,dc=<COMPANY>,dc=com" "(&(objectclass=person))" uid -j 500
Please enter bind password:
uid=<UID>,ou=Users,dc=<COMPANY>,dc=com
uid=<UID>

real 0m47.848s
user 0m0.020s
sys 0m0.010s


log output:

[2017-10-18T10:18:11.135395+11:00] [OID] [TRACE:16] [] [OIDLDAPD] [host: <OID_HOSTNAME>] [pid: xxxxx] [tid: 17] [ecid:xxxxxxxxxxxxxx] ServerWorker (REG):[[ BEGIN ConnID:2354024 mesgID:2 OpID:1 OpName:search ConnIP:XX.XX.XX.XXX:29033 ConnDN:cn=orcladmin gslfeFindInMemFilt:Could not form valid filter for string (&) using filter (&(objectclass=person))

2017-10-18T10:18:11.135435 * INFO :gslfseADoSearch BASE = uid=<UID>,ou=Users,dc=<COMPANY>,dc=com FILTER = (&(objectclass=person)) #REQDATTR = 1 SCOPE = 2 REQDATTRS = uid TIMELIMIT = 3600 SIZELIMIT = 0 DEREF = 0 2017-10-18T10:18:11.135494 * gslsbsSearch * BASE = "uid=<UID>,ou=Users,dc=<COMPANY>,dc=com" FILTER = "(&(objectclass=person))" SCOPE = 2

2017-10-18T10:18:11.135532 * gslfbpsParsePagingCtrlValue: exit with status = 0 pagesize = 500

2017-10-18T10:18:47.308372 * INFO:gsleswrASndResult OPtime=36173208 micro sec RESULT=0 tag=101 nentries=1 2017-10-18T10:18:47.308424 * Qtime=0 micro sec END ]]

+. However when there is no mention if the page size, the query is quick.

 time ldapsearch -h <OID_HOSTNAME> -p <PORT> -D cn=orcladmin -w <PASSWORD> -b "uid=<UID>,ou=Users,dc=<COMPANY>,dc=com" "(&(objectclass=person))" uid
Please enter bind password:
uid=<UID>,ou=Users,dc=<COMPANY>,dc=com
uid=<UID>

real 0m4.557s
user 0m0.010s
sys 0m0.020s

Cause

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