INPLACEDATAWRITEMARGINPERCENT

In-place data writing can help reduce data fragmentation and lower the need for frequent restructuring of the Essbase cube. It also reduces the need for frequent index updates, resulting in improved performance.

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

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.

Use this configuration only when ORACLEHARDWAREACCELERATION is true, and in-place data writing is enabled.

INPLACEDATAWRITEMARGINPERCENT configuration applies only to block storage (BSO) databases, and does not apply to aggregate storage (ASO) databases.

Syntax

INPLACEDATAWRITEMARGINPERCENT n

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

Example

INPLACEDATAWRITEMARGINPERCENT 25