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
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.