Skip to content

Manage Oracle Indexes

Manage Oracle Indexes

Oracle Index Managementis a tool for validating and rebuilding indexes. First one validates indexes either by running a scheduled task (that validates all indexes as a background job) or validates indexes one by one. Depending the result of the validation one can determine whether to rebuild (or coalesce) or do nothing. It is possible to rebuild all indexes in a scheduled task or to rebuild them one by one.

Note: Validation and Rebuilding of indexes may lock indexes and it is possible that it can cause the application to hang. Therefore one should use this tool when there is a minimum of activity within the application.

Actions

Method Description
Validate Index(s) Validates one or more marked indexes.
Rebuild Index(s) Rebuild one or more marked indexes.
Coalesce Index(s) Coalesces one or more marked indexes.
Validate All Indexes Schedules a task that validates indexes, the task can be reoccurring.
Rebuild All Indexes Schedules a task that rebuilds all indexes, the task can be reoccurring.