My Oracle Support Banner

OUD 11g/12c - Deletes Taking Longer After Enabling Referential Integrity (RI) Constraint on Some DN Attributes (Doc ID 2296322.1)

Last updated on DECEMBER 13, 2019

Applies to:

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


When Referential Integrity (RI) using either manager or secretary attributes (or both), the delete performance is poor with delete times taking up to 6 seconds -

$time ldapdelete -x -h <HOST> -p <PORT> -D "cn=<DS_ADMIN>" -w <PASSWORD> 'cn=<TEST_GROUP>,ou=groups,dc=<SUFFIX_DN>' -v
ldap_initialize( ldap://<HOST>:<PORT> )
deleting entry "cn=<TEST_GROUP>,ou=groups,dc=<SUFFIX_DN>"

real 0m6.918s
user 0m0.000s
sys 0m0.003s



Referential integrity checking enabled on DN attributes (manager, secretary) in OUD. The RI is working as expected but ever since RI was enabled, any DELETES on objects (any kind of identity including users or groups) is taking longer to complete.

Below is the configuration



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

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