INPLACEDATAWRITE

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.

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 INPLACEDATAWRITE 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.

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

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.

Example

INPLACEDATAWRITE Sample Basic FALSE