MEMORYMAPPEDDATA

When ORACLEHARDWAREACCELERATION is enabled, the MEMORYMAPPEDDATA configuration setting enables performance improvements for Essbase block storage (BSO) databases.

Areas in which performance is improved include data load, serial and parallel calculation, export, and restructuring, especially for remote storage (NFS). Setting MEMORYMAPPEDDATA to TRUE improves in-memory computing of Essbase block storage databases by using memory mapped I/O for page files.

Note:

Virtual memory usage will be equal to the size of the sum of page files in the database.

Syntax

MEMORYMAPPEDDATA [appname [dbname]] TRUE | FALSE

appname—Optional. Specifies the application for which to enable memory mapped data. If you specify a value for appname and do not specify a value for dbname, the setting applies to all cubes in the specified application. To enable the setting for a specific database, you must specify an application and cube.
dbname—Optional. Specifies the database (cube), in the application specified by appname, for which to enable memory mapped data. If you specify a value for dbname but do not specify a value for appname, your specification is ignored.
TRUE—Enables memory mapped data.
FALSE—Disables memory mapped data. This is the default.

Example

MEMORYMAPPEDDATA Sample Basic TRUE