Performance Troubleshooting

This section gives some quick pointers for common performance related problems.

If LDAP search performance is poor, make sure that:

• The attributes on which the search is being made are indexed

• Schema associated with the ODS user is ANALYZED

  For searches involving multiple filter operands, make sure that the order in which they are given goes from the most specific to the least specific. For example, &(l=Chicago)(state=Illinois)(c=US) is better than &(c=US)(state=Illinois)(l=Chicago).

If LDAP add or modify performance is poor, make sure that:

• There are enough redo log files in the database

• The undo tablespace in the database is large enough

• The schema associated with the ODS user is ANALYZED

You can also use the OID Database Statistics Collection tool to analyze the various database ods schema objects to estimate the statistics.

See Also: "OID Database Statistics Collection Tool (oidstats.sh) Syntax" for instructions on using the OID Database Statistics Collection tool