My Oracle Support Banner

OUD 11g / 12c Performance Issues with Ismemberof Searches Due to Insufficient FIFO Entry Cache Memory Settings (Doc ID 2220959.1)

Last updated on DECEMBER 06, 2019

Applies to:

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

Symptoms

Searches that request the ismemberof attribute or reference it in the search filter are taking a long time to return results.  For example...

dn: uid=<UID.1>,cn=users,dc=<SUFFIX_DN>
isMemberof: <truncated>
isMemberof: <truncated>

real 0m28.577s
user 0m1.641s
sys 0m0.054s

[19/Oct/2016:06:56:38 -0600] CONNECT <......> from=<CLIENT_IP>:<CONN> to=<SERVER_IP>:<PORT> protocol=LDAPS
[19/Oct/2016:06:56:38 -0600] BIND REQ <......> op=0 msgID=1 type=SIMPLE dn="cn=<DS_ADMIN>"
[19/Oct/2016:06:56:38 -0600] BIND RES <......> op=0 msgID=1 result=0 authDN="cn=<DS_ADMIN>,cn=Root DNs,cn=config" etime=1
[19/Oct/2016:06:56:38 -0600] SEARCH REQ <......> op=1 msgID=2 base="cn=users,dc=<SUFFIX_DN>" scope=sub filter="(uid=<TEST_USER>)" attrs="isMemberof"
[19/Oct/2016:06:57:06 -0600] SEARCH RES <......> op=1 msgID=2 result=0 nentries=1 etime=27546
[19/Oct/2016:06:57:06 -0600] UNBIND REQ <......> op=2 msgID=3
[19/Oct/2016:06:57:06 -0600] DISCONNECT <......> reason="Client Disconnect"

[18/Oct/2016:14:30:43 -0600] SEARCH REQ <.....> op=1 msgID=2 base="cn=users,dc=<SUFFIX_DN>" scope=sub filter="(&(isMemberOf=cn=<STATIC_GROUP>,cn=groups,dc=<SUFFIX_DN>)(<CUSTOM_ATTR-1>=35))" attrs="<CUSTOM_ATTR-2>,<CUSTOM_ATTR-3>"
[18/Oct/2016:14:31:18 -0600] SEARCH RES <.....> op=1 msgID=2 result=0 nentries=130 etime=35347

[18/Oct/2016:14:27:09 -0600] SEARCH REQ <......> op=1 msgID=2 base="cn=users,dc=<SUFFIX_DN>" scope=sub filter="(isMemberOf=cn=<STATIC_GROUP>,cn=groups,dc=<SUFFIX_DN>)" attrs="<CUSTOM_ATTR-2>,<CUSTOM_ATTR-3>"
[18/Oct/2016:14:27:30 -0600] SEARCH RES <......> op=1 msgID=2 result=0 nentries=1601 etime=21583

[18/Oct/2016:14:28:12 -0600] SEARCH REQ conn=4992 op=1 msgID=2 base="cn=users,dc=<SUFFIX_DN>" scope=sub filter="(<CUSTOM_ATTR-1>=35)" attrs="<CUSTOM_ATTR-2>,<CUSTOM_ATTR-3>"
[18/Oct/2016:14:28:18 -0600] SEARCH RES conn=4992 op=1 msgID=2 result=0 nentries=672 etime=5668

Changes

 

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
Changes
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.