EnableParallelRedo

The parallel redo feature improves database recovery by using multiple CPU threads to apply redo transaction logs simultaneously instead of sequentially.

If you set the EnableParallelRedo attribute to 1, parallel redo is enabled. Setting EnableParallelRedo=0 disables parallel redo, and the database uses the legacy redo method instead. If the new default parallel redo method fails or lengthens the recovery time, you can disable it by setting the connection attribute EnableParallelRedo=0. The default value is 1.

When parallel redo is enabled:
  • The transaction log is divided into segments based on the RedoSegmentSize connection attribute. See RedoSegmentSize.
  • Within each segment, multiple redo recovery threads (as defined by RedoParallelism) reapply the transaction log records concurrently. See RedoParallelism.
  • Once all redo records in one segment are processed, parallel redo proceeds to read and process the next segment until recovery completes.

For details on how to configure this attribute, see Parallel Redo Recovery in TimesTen Database in the Oracle TimesTen In-Memory Database Operations Guide.

Required Privilege

Only the instance administrator can change the value of this attribute.

Setting

Set EnableParallelRedo as follows:

Where to set the attribute How the attribute is represented Setting

C or Java programs or UNIX and Linux systems odbc.ini file in TimesTen

EnableParallelRedo

0 - Disable

1 - Enable (default)

Windows ODBC Data Source Administrator

Not applicable

Not applicable