MEMORYMAPPEDDATA

When ORACLEHARDWAREACCELERATION is true, this Essbase configuration setting improves in-memory computing of block storage databases by using memory mapped I/O for page files.

Areas in which performance is improved include data load, serial and parallel calculation, export, and restructuring, especially for remote storage (NFS).

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