Recovery Tuning

You can improve the performance of database recovery after database shutdown or system failure.

Set RecoveryThreads

Performance impact: Large

RecoveryThreads defines the number of parallel threads used to rebuild indexes during database recovery time.

For performance reasons, TimesTen does not log changes to indexes. In the event of a crash, all indexes need to be rebuilt. To reduce the index rebuild time, set the RecoveryThreads attribute to the number of CPUs to improve recovery performance. See RecoveryThreads in the Oracle TimesTen In-Memory Database Reference.

Set CkptReadThreads

Performance impact: Large

When a database has large checkpoint files (hundreds of gigabytes), first connection or recovery operations may not perform well and, in extreme cases, may take hours to complete.

To improve recovery performance, use the CkptReadThreads connection attribute to increase the number of concurrent threads used for reading the checkpoint files during the loading of the database into memory. This reduces the amount of time it takes to load the TimesTen database to memory by enabling parallel threads to read the TimesTen database checkpoint files.

See CkptReadThreads in the Oracle TimesTen In-Memory Database Reference.