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 laterInformation 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 |