Data Block Size

Data block size is determined by the amount of data in a particular combination of dense dimensions. For example, when you change the dense or sparse configuration of one or more dimensions in the database, the data block size changes. Data block size is 8n bytes, where n is the number of cells that exist for that combination of dense dimensions.

Note:

The optimum size range is 8 KB to 100 KB.

For information about determining the size of a data block, see Size of Expanded Data Block.

  To view the block size for a database, use a tool:

Tool

Topic

Location

Administration Services

Checking Data Block Statistics

Oracle Essbase Administration Services Online Help

ESSCMD

GETDBSTATS

Oracle Essbase Technical Reference