My Oracle Support Banner

OUD 12c - Poor Search Performance Observed with the "ldapsearch" Command Using "caseExactMatch" (Doc ID 2916470.1)

Last updated on JANUARY 04, 2023

Applies to:

Oracle Unified Directory - Version 12.2.1.4.220405 and later
Information in this document applies to any platform.

Symptoms

Poor search performance observed with "ldapsearch" caseExactMatch

We have observed Poor search performance with "ldapsearch" caseExactMatch.
OUD Version: 12.2.1.4.220405

Example:
search using "caseExactMatch":
./ldapsearch -p <OUD_PORT> -D <DS_ADMIN> -j <PWD_FILE> -b <BASE_DN> uid:caseExactMatch:=<UID> cn mail

dn: <DN>
mail: <MAIL>
cn: <CN>

access:
[10/Aug/2022:12:35:02 +0000] SEARCH REQ conn=6 op=1 msgID=2 base="<BASE_DN>" scope=sub filter="(uid:caseExactMatch:=<UID>)" attrs="cn,mail"
[10/Aug/2022:12:35:36 +0000] SEARCH RES conn=6 op=1 msgID=2 result=0 nentries=1 additionalInfo="Unindexed" etime=33623
➜ etime is 33 seconds.

search without caseExactMatch:

./ldapsearch -p <OUD_PORT> -D <DS_ADMIN> -j <PWD_FILE> -b <BASE_DN> uid=<UID> cn mail
dn: <DN>
mail: <MAIL>
cn: <CN>

[10/Aug/2022:12:36:43 +0000] SEARCH REQ conn=7 op=1 msgID=2 base="<BASE_DN>" scope=sub filter="(uid=<UID>)" attrs="cn,mail"
[10/Aug/2022:12:36:43 +0000] SEARCH RES conn=7 op=1 msgID=2 result=0 nentries=1 etime=3 
➜ etime is 3 ms.



Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


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