Estimating Total Essbase Memory Requirements

You can use Table 252 as a worksheet on which to calculate an estimate of the total memory required on the server.

Table 252. Worksheet: Total Server Memory Requirement

Component

Memory Required (MB)

Sum of application startup memory requirementsThis image of a space is used for formatting purposes only.

See Estimating Startup Memory Requirements for Applications.

ML:This image of a space is used for formatting purposes only.

In rows a–g, list concurrent databases (from copies of Table 250, Worksheet: Estimating Memory Requirements for a Database) and enter their respective memory requirements (MH) in the column to the right.

a.

MH:

b.

MH:

c.

MH:

d.

MH:

e.

MH:

f.

MH:

g.

MH:

Operating system memory requirement

MN:

Total estimated memory requirement for the server

MO:

  To estimate the total Essbase memory requirement on a server:

  1. In the cell labeled ML, record the total startup memory requirement for applications, as described in Estimating Startup Memory Requirements for Applications.

  2. List the largest set of databases that will run concurrently on the server. In the Memory Required column, for the MH value for each database, note the memory requirement estimated in the database requirements worksheet, Table 250, Worksheet: Estimating Memory Requirements for a Database.

  3. Determine the operating system memory requirement, and write the value in megabytes to the cell labeled MN in Table 252.

  4. Total all values and write the result in the cell labeled MO.

  5. Compare the value in MN with the total available random-access memory (RAM) on the server.

Note:

In addition, consider memory requirements for client software, such as Oracle Essbase Administration Services, that may be installed on the Essbase Server computer. See the Oracle Hyperion Enterprise Performance Management System Installation Start Here.

If cache memory locking is enabled, the total memory requirement should not exceed two-thirds of available RAM; otherwise, system performance can be severely degraded. If cache memory locking is disabled, the total memory requirement should not exceed available RAM.

If insufficient memory is available, you can redefine the cache settings and recalculate the memory requirements. This process can be iterative. See Fine-Tuning Cache Settings. In some cases, you may need to purchase additional RAM.