INPLACEDATAWRITE

This Essbase configuration setting enables or disables in-place data writing as an alternative to block updates requiring new disk locations.

Use this configuration only when ORACLEHARDWAREACCELERATION is true.

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

INPLACEDATAWRITE [appname [dbname]] TRUE|FALSE

appname—Optional. If provided, the setting applies only to the specified application; otherwise, the setting applies to all applications.
dbname—Optional. Specifies the database (cube) in the application specified by appname. If you specify a value for dbname but do not specify a value for appname, your specification is ignored.
TRUE—In-place data writing is enabled when ORACLEHARDWAREACCELERATION is true. This is the default.
FALSE—In-place data writing is disabled.

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

INPLACEDATAWRITE Sample Basic FALSE