Configure Database Index Rebuilds
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. Enter 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 DAYS_BETWEEN_INDEX_REBUILDS in the system parameters.
UPDATE ptl_system_parameter set param_value=30 WHERE param_name=’DAYS_BETWEEN_INDEX_REBUILDS’; commit; |