Checking Data Block Statistics

You can check the efficiency of a database by viewing statistics on data blocks, such as block size, block density, and compression ratio.

Note:

These statistics do not apply to aggregate storage databases.

  To check block statistics for a database:

1. From Enterprise View or a custom view, select a database.

2. Right-click and select Edit, then Properties.

3. In the Database Properties window, select Statistics.

4. Expand the Blocks node to view block statistics.

Related Information

• Database Properties Window—Statistics Tab

• “Basic Architectural Elements” in the Oracle Essbase Database Administrator's Guide

• Improving Essbase Performance in the Oracle Essbase Database Administrator's Guide

Related Commands

• getdbstats (ESSCMD) in the Oracle Essbase Technical Reference

• getperfstats (ESSCMD) in the Oracle Essbase Technical Reference