The RebuildOptimizationInterval Parameter is not Interpreted Properly (Doc ID 1545384.1)

Last updated on DECEMBER 18, 2023

Applies to:

Symptoms

The RebuildOptimizerInterval parameter is not a time period interval, it is a delta based on the number of content items added + number of content items deleted + number of content items updated.

By default that delta number is 50000. When the change delta exceeds 50000, the optimizer gets executed.

Even if the parameter number is set and increased in the config.cfg file, the WebCenter Content server ignores the setting and will invoke the optmizer when 50000 changes are reached.

If a large number of content items are constantly added, deleted, or updated, this may cause the index to have the optimize process running almost all of the time. That may cause slow interactions between the WebCenter Content server and the database which usually manifests as a performance issue.

If the optimizer runs during an index collection rebuild, that also may cause the indexing to hang.

Cause

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