Changing the Initialization Profile to Speed Up Reorganization 

Use

You can improve the performance of an Oracle reorganization with SAPDBA by changing certain parameter values in the initialization profile init<DBSID>.ora before starting the reorganization.

• Only make these changes for the duration of the reorganization.
• Stop the SAP System before starting this procedure.

1. Write down the original values of parameters sort_area_size and db_file_multiblock_read_count .
2. Change the parameter sort_area_size to 8388608.

This increases the sort buffer to 1024 blocks of 8 KB each.

3. Change the parameter db_file_multiblock_read_count to 64.

This increases the number of blocks read or written for each I/O operation.

4. Start up the database in restricted session mode.

Now you can perform the reorganization.

5. After the reorganization, return the parameters to their original values before you start up the database and the SAP System for production use.