Checking the Compression Ratio

The compression ratio represents the ratio of the compressed block size (including overhead) to the uncompressed block size, regardless of the compression type in effect. Overhead is the space required by mechanisms that manage compression/expansion.

  To check the compression ratio, use a tool:

Tool

Topic

Location

Administration Services

Checking the Compression Ratio

Oracle Essbase Administration Services Online Help

ESSCMD

GETDBSTATS

Oracle Essbase Technical Reference

Note:

The larger the number, the more compression. The compression ratio can vary widely from block to block.