Applies to:

Oracle Internet Directory - Version 11.1.1.2.0 to 11.1.1.6.0 [Release 11g]Information in this document applies to any platform.

Symptoms

High number of DB password policy refresh execution when lot of user entries has pwdpolicysubentry attribute. This event will trigger OID to refresh its passwordPolicySubentry cache, which will cause a huge SQL query requests to the database if there are lots of such users, this issue is causing an intermittent ldap query delay.

Following is the SQL query that the oidldapd process is running every few seconds and that is causing a lot of traffic: