Modify the Database Index Rebuild Run Time
To improve the performance of index recreation, a system parameter can be configured to define the number of minutes the index rebuild should run. The default value is 10 minutes. If the rebuild takes longer than this time, the job will stop. In very large environments, it may be necessary to increase this time to accommodate large indexes.
Use the following procedure to the number of leaf blocks in a database index.
1. Log in to the Portal Server as user aptare.
2. Type the following command:
sqlplus portal/<portal_password>
3. Update the value for MAX_TOT_INDX_JOB_RUN_TIME_MINS system parameter.
UPDATE ptl_system_parameter set param_value=<NEW_VALUE> WHERE param_name='MAX_TOT_INDX_JOB_RUN_TIME_MINS';
commit;