DefragCycle
The DefragCycle specifies the number of seconds to wait
before the next cycle of the online defragmentation.
If DefragCycle=0, online defragmentation keeps scanning tables
for fragmentation, even when no fragmentation is present in the tables. This leads to
unnecessary consumption of CPU resources.
If you set DefragCycle to a non-zero value, it can help reduce the CPU
usage.
If you change the DefragCycle value while the defragmentation
is waiting for the next DefragCycle, the next round of defragmentation is
performed after the number of seconds specified by the new DefragCycle. For
example, if you set the DefragCycle value to 60 and update
to 120 after 30 seconds have passed since the last
defragmentation, TimesTen schedules the next defragmentation round in 120
seconds instead of the remaining 30 seconds. 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 DefragCycle as follows:
| Where to set the attribute | How the attribute is represented | Setting |
|---|---|---|
|
C or Java programs or UNIX and Linux systems
|
|
Default value: Maximum value: |