1. Configuration Reference for Oracle Essbase
  2. Essbase Configuration Settings
  3. Config Settings List
  4. MAX_RESPONSE_GRID_SIZE

MAX_RESPONSE_GRID_SIZE

This Essbase configuration setting specifies the maximum size of the response grid. The response grid is the number of cells that the target (an aggregate storage database) sends to the source.

The amount of memory required to temporarily hold the response grid in the data target is proportional to the size of the request grid (MAX_REQUEST_GRID_SIZE). In the case of a huge request grid with millions of cells, the amount of memory required for the response grid to be sent in one operation could pose problems (for example, the system could reach memory boundaries or fail to allocate enough memory). With the MAX_RESPONSE_GRID_SIZE configuration setting, Essbase splits the request grid into slices of data and sends multiple, smaller response grids to the source.

Syntax

MAX_RESPONSE_GRID_SIZE [appname [dbname]] n

  • appname—Optional. Specifies the application for which the response grid size is to be set.

    If you specify a value for appname and do not specify a value for dbname, the setting applies to all databases in the specified application.

    To enable the setting for a specific database, you must specify an application and database.

    If you do not specify an application, you cannot specify a database, and the setting applies to all applications and databases on Essbase Server.

  • dbname—Optional. Specifies the database, in the application specified by appname, for which the response grid size is to be set.

    If you specify a value for dbname but do not specify a value for appname, your specification is ignored, and logging diagnostic messages is enabled for all applications and databases on Essbase Server.

  • n—Specifies the size of the slice of the response grid to be sent to the data target.

    The default value is one million (1000000) cells, which requires 8 MB of memory.

    For example, if MAX_REQUEST_GRID_SIZE is set to one billion (1000000000) cells and MAX_RESPONSE_GRID_SIZE is set to one million (1000000) cells, the size of the response grid is one thousand (1000) cells.

You must restart Essbase Server to initialize any change to the configuration file.

Example

MAX_RESPONSE_GRID_SIZE ASOSamp 500000

Limits the response grid to a half-million cells (which requires 4 MB of memory) for all databases associated with the ASOSamp application.

See Also

MAX_REQUEST_GRID_SIZE configuration setting