Define a Large Database Index
In large environments, to improve the performance of index builds, a system parameter can be configured to define the number of leaf blocks for a large index. The default value is 10,000 leaf blocks.
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 LARGE_INDEX_NUM_LEAF_BLOCKS system parameter.
UPDATE ptl_system_parameter set param_value=<NEW_VALUE> WHERE param_name='LARGE_INDEX_NUM_LEAF_BLOCKS';
commit;