Modify the Maximum Number of Large Database Indexes
To improve the performance of index recreation, a system parameter can be modified to change the number of large database indexes that will be processed in a single run. The default value is 10.
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 the 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;