When starting the policy server, we can see that it takes some time to start because it spends some time on loading objects in its cache.
Oracle directory server 11g is used as Policy Store.
By checking the LDAP logs associated, we can see that the indexes are not used properly and even by recreating the indexes it does not help for queries like:
SRCH base="ou=xps,ou=policysvr4,ou=siteminder,ou=netegrity,o=xxxxxx" scope=2 filter="(&(xpsNumber=*)(!(xpsTombstone=*)))" attrs="objectClass"
Using the out of the box XPS/OracleDirectoryServer.ldif indexes does not help in this specific situation and needs to be modified depending on the based structure as the policy store was an upgrade form the 5.x version and did not respect the correct tree.
The script try to add the index on dn:
but we haven't this kind of schema. we have this:
Script need to be accomodated accordingly.