Speeding Up a Reorganization 

Use

You can speed up a reorganization by changing certain parameter values in the initialization profile init<DBSID>.ora before starting the reorganization.

Prerequisites

Only make these changes for the duration of the reorganization. Reset the old values after the reorganization.

Make sure that the R/3 System has been shut down before you start up the database.

Procedure

  1. Write down the original values of parameters sort_area_size and db_file_multi_block_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 eacg I/O operation.
  4. Start up the database in DBA mode (the R/3 System must be shut down) and perform your reorganization.
  5. After the reorganization, return the parameters to their original values before you start up the database and the R/3 System for production use.