OID 11g: Performance Issue With Paged Ldapsearch Query to OID when Compared to Non-paged Ldapsearch.

(Doc ID 2341813.1)

Last updated on JANUARY 03, 2018

Applies to:

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

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 /oracle/app/product/fmw/idm/bin/ldapsearch -h localhost -p 8081 -D cn=orcladmin -q -b "uid=raju,ou=Internal Users,dc=oracle,dc=com" "(&(objectclass=person))" uid -j 500
Please enter bind password:
uid=raju,ou=internal users,dc=oracle,dc=com
uid=raju

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


log output:

[2017-10-18T10:18:11.135395+11:00] [OID] [TRACE:16] [] [OIDLDAPD] [host: XXXXXXXXX] [pid: 21446] [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=raju,ou=Internal Users,dc=oracle,dc=com,dc=au FILTER = (&(objectclass=person)) #REQDATTR = 1 SCOPE = 2 REQDATTRS = uid TIMELIMIT = 3600 SIZELIMIT = 0 DEREF = 0 2017-10-18T10:18:11.135494 * gslsbsSearch * BASE = "uid=raju,ou=internal users,dc=oracle,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.

[oracle@sviam0000002pr ~]$ time /oracle/app/product/fmw/idm/bin/ldapsearch -h localhost -p 8081 -D cn=orcladmin -q -b "uid=raju,ou=Internal Users,dc=oracle,dc=com" "(&(objectclass=person))" uid
Please enter bind password:
uid=raju,ou=internal users,dc=oracle,dc=com
uid=raju

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

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