Enabling In-Place Data Writing with Exalytics

Остаются только детские эмоции, когда в угоду продаж железок портят софт. Теперь даже не будет предприниматься и попытки использовать старое место блока для записи .

——————–

The INPLACEDATAWRITE setting in essbase.cfg enables or disables in-place data writing.

Prior to this release, each time a data block was updated, it was written to a new disk location. With this release, for Exalytics, Essbase enables in-place data writing.

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 database. It also reduces the need for frequent index updates, resulting in improved performance.

Syntax and Usage of INPLACEDATAWRITE

INPLACEDATAWRITE [appname [dbname]] TRUE | FALSE

Keyword Description
appname Optional. If provided, the setting applies only to the specified application; otherwise, the setting applies to the Essbase Server.
dbname Optional. If provided, specifies the database.
TRUE In-place data writing is enabled for Exalytics. This is the default.
FALSE In-place data writing is disabled.

Notes

  • This configuration setting applies only when the ORACLEHARDWAREACCELERATION configuration  setting is set to TRUE.
  • If you set INPLACEDATAWRITE to TRUE, there is a risk to data integrity if Essbase terminates abnormally.

Example

INPLACEDATAWRITE Sample Basic FALSE

  • Roman Kolchin

    u041fu043eu0447u0435u043cu0443 u043fu043eu0440u0442u044fu0442? u0412u0441u0435 u0440u043eu0432u043du043e u043du0430u043eu0431u043eu0440u043eu0442 – u044du0442u043e u0440u0430u043du044cu0448u0435 Essbase u043fu0438u0441u0430u043b u0434u0430u043du043du044bu0435 u0432u0441u0435u0433u0434u0430 u043du0430 u043du043eu0432u043eu0435 u043cu0435u0441u0442u043e, u0430 u0442u0435u043fu0435u0440u044c u043fu043eu044fu0432u0438u043bu0430u0441u044c u0432u043eu0437u043cu043eu0436u043du043eu0441u0442u044c u043fu0438u0441u0430u0442u044c u043eu0431u0440u0430u0442u043du043e – “Prior to this release, each time a data block was updated, it was written to a new disk location”. u041du0430u043fu0440u0438u043cu0435u0440, u0437u0434u0435u0441u044c u043du0430u043fu0438u0441u0430u043du043e u043au0430u043a u044du0442u043e u043cu043eu0436u043du043e u043fu0440u043eu0432u0435u0440u0438u0442u044c http://goo.gl/UqdddJ. u0414u0430u043du043du0430u044f u043eu043fu0446u0438u044f u0441u0442u0430u043bu0430 u0438u043cu0435u0442u044c u0441u043cu044bu0441u043b u0442u043eu043bu044cu043au043e u0441u0435u0439u0447u0430u0441, u043au043eu0433u0434u0430 u043fu043eu044fu0432u0438u043bu0438u0441u044c SSD-u0434u0438u0441u043au0438, u0443 u043au043eu0442u043eu0440u044bu0445 u0441u043au043eu0440u043eu0441u0442u044c u043fu0440u043eu0438u0437u0432u043eu043bu044cu043du043eu0439 u0437u0430u043fu0438u0441u0438 u043du0435u0441u0443u0449u0435u0441u0442u0432u0435u043du043du043e u043cu0435u043du044cu0448u0435 u043bu0438u043du0435u0439u043du043eu0439. u0412 u0447u0430u0441u0442u043du043eu0441u0442u0438, SSD u0438u0441u043fu043eu043bu044cu0437u0443u0435u0442u0441u044f u0432 u043fu043eu0441u043bu0435u0434u043du0435u0439 Exalytics’u0435.