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
See Also