Modify the Database Index Rebuild Frequency
In large environments, if report generation performance begins to degrade, database indexes can be built more frequently. The default is to rebuild indexes every 60 days.
Use the following procedure to configure the frequency of index builds in the system parameters.
1. Log in to the Portal Server as user aptare.
2. Type the following command:
sqlplus portal/<portal_password>
3. Locate the default value.
SELECT param_value
FROM ptl_system_parameter
WHERE param_name='DAYS_BETWEEN_INDEX_REBUILDS';
4. Update the value for the DAYS_BETWEEN_INDEX_REBUILDS system parameter.
UPDATE ptl_system_parameter set param_value=30 WHERE param_name='DAYS_BETWEEN_INDEX_REBUILDS';
commit;