INPLACEDATAWRITEMARGINPERCENT
This Essbase configuration setting defines how much extra margin to allow in the data block for writebacks. This helps prevent any fragmentation that could be caused if writes use a new page location.
Use this configuration only when ORACLEHARDWAREACCELERATION is true, and in-place data writing is enabled.
In-place data writing means that when updates occur, the data block can be written to the same location, as long as the compressed size of the data block fits in its original location on the disk.
Syntax
INPLACEDATAWRITEMARGINPERCENT nn—A margin percentage of additional block space to allow for a writeback, so it can avoid allocating a new page location. The default is 20.
Description
In-place data writing can help reduce data fragmentation and lower the need for frequent restructuring of the cube. It also reduces the need for frequent index updates, resulting in improved performance.
Example
INPLACEDATAWRITEMARGINPERCENT 25