Enabling Cache Memory Locking

You can enable cache memory locking for databases for which you have Database Manager permissions. By default, cache memory locking is turned off.

Note:

This setting does not apply to aggregate storage databases.

Memory locking may improve database performance, because the system memory manager does not have to swap and reserve memory for Essbase caches.

Memory-locking changes become effective after the database is stopped and restarted.

  To enable cache memory locking for databases:

  1. From Enterprise View or a custom view, select a database.

  2. Right-click, and select Edit, and then Properties.

  3. In the Database Properties window, select the Caches tab.

  4. Select Cache memory locking.  

  5. Click Apply.

Related Information

Related Commands