Before you start the estimate, calculate factors to be used in calculating the estimate.
Table 249 lists sizing factors with references to sections in this chapter and other chapters that provide information to determine these sizes. Go to the section indicated, perform the calculation, and return to Table 249. Write the size, in bytes, in the Value column this worksheet.
Later in this chapter, you can refer to Table 249 for values to use in various calculations.
Table 249. Worksheet: Factors Used to Calculate Database Memory Requirements
The number of threads allocated through the SERVERTHREADS ESSCMD See the Oracle Essbase Technical Reference. | |
The calculations in this chapter do not account for the following factors that have complex implications on how much memory is used and are not included in the discussion:
Cache memory locking. Whether ache memory locking is enabled affects how the operating system and Essbase manage memory. See Deciding Whether to Use Cache Memory Locking.
Different operation types and their associated cache allocations. Data load, data retrieval, and calculation operations set aside memory for the data file, data, and calculation caches, plus some overhead associated with the caches.
The sizes of the retrieval buffer and the retrieval sort buffer. See Changing Buffer Size for a discussion of the significance of the size of the retrieval buffer and the retrieval sort buffer.
Database workload; for example, the complexity of a calculation script or the number and complexity of data queries.
The number of data blocks defined using the CALCLOCKBLOCK setting in the essbase.cfg file in combination with the SET LOCKBLOCK setting, which specifies which CALCLOCKBLOCK setting to use.
The number of Dynamic Calc members in the outline, including members of attribute dimensions.