OVD 11g Slow Performance With Oracle DB and OID LDAP Join Adapter
Last updated on MARCH 08, 2017
Applies to:Oracle Virtual Directory - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
Oracle Virtual Directory (OVD) 11g, i.e., 18.104.22.168.
OVD slow performance using a join adapter between an Oracle Database (DB) and Oracle Internet Directory (OID).
- Direct queries to the database and OID instance return results in less than 1 second.
- Direct queries through OVD with a join on the Oracle DB and OID return results in over 1 minute.
- Oracle Identity Manager (OIM) is reconciling users using this Join view at a rate of 2000 users / hour.
Tried applying the NIO false workaround as per <Document 1451212.1>, unchecking "Enable Case Insensitive Search" in the DB adapter, applying documented OVD and JVM tuning, however saw only slight performance improvement afterwards.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms