DefragSpeed

The DefragSpeed attribute enables you to ensure how fast the online defragmentation is done.

For lower DefragSpeed values, the defragmentation process runs slowly using less CPU time. When the DefragSpeed value is set to 0, online defragmentation is disabled.

Higher values lead to faster defragmentation and use more CPU resources, which leads to a greater chance of lock contention. This is due to defragmentation running on a single thread. For details, see Online Defragmentation of TimesTen Databases in the Oracle TimesTen In-Memory Database Operations Guide.

Required Privilege

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

Setting

Set DefragSpeed 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

DefragSpeed
  • 0 - disabled (default)
  • 1 - low
  • 2 - medium
  • 3 - high

Note:

You can view or modify the setting using ttDBConfig built-in. See ttDBConfig.