Editing the index maintenance configuration file

Log into the Oracle Server as oracle (Solaris) or Administrator (Windows).

Open the /usr/mvf/etc/index_upkeep.cfg (Solaris) or the C:\mvf\etc\indes_upkeep.cfg (Windows) file.

Edit two parameters to suit your specific requirements:

1. MAXHOURS—how long, in hours, you want the index_rebuild script to run. It always rebuilds a minimum of one index and, if that index is large, the time taken may exceed your MAXHOURS specification. The minimum value is 1 hour. The default value is 2 hours.

   For the first few times you run the index_rebuild script, we recommend that you allow a minimum 4-hour window for the rebuild. Depending on the current size of the database, it may take 6 hours or more to rebuild only the largest index.

2. REBUILD_FREQUENCY—how often, in days, an index should qualify for being rebuilt.

   The default value is 120 days.

Save and close the index_upkeep.cfg file.