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

Last updated on MARCH 06, 2023

Applies to:

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

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