OUD Performance Tuning - How to Enable the Dynamic Index Analyzer and View the Statistics Collected (Doc ID 2547532.1)

Last updated on JANUARY 11, 2023

Applies to:

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

Goal

Example of using the index filter analyzer
The Test Performed: The index entry limit was lowered from 4k to 50 based on having only 200 entries in the OUD instance to simulate an unindexed search on the userRoot database backend (<SUFFIX_DN>) for the search filter requiring an presence index for the uid attribute.

Configuration Reference - index-filter-analyzer-enabled

Solution

	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

1) Verify the available backends

2) View the configured properties of the userRoot backend

3) Enable the dynamic index analyzer on the userRoot backend

4) Verify the index-filter-analyzer-enabled property is enabled

5) Querying cn=monitor to determine the DN to search against and return statistical data

a) Execute a search against the Administration Port to determine the DN required to search against in order to view the statistical data

b) Execute search using the Administration Port against the DN determined from the output of the previous step (above) to review the statistical data.

6) Execute the verify-index command for subsequent validation of indexes that require a re-index

7) Rebuild the associated indexes

8) Execute the verify-index command, to check the indexes that have exceeded the entry limit is feasible

9) Executing a subsequent search with search filter (uid=*)

10) Searching for statistical data verifies that index entry limit has been exceeded

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