Viewing Fragmentation Statistics

You can measure fragmentation using the average clustering ratio statistic for a database. This statistic indicates the fragmentation level of the data (.pag) files. The maximum value, 1, indicates no fragmentation.

Note:

This statistic does not apply to aggregate storage databases.

To view fragmentation statistics for a database:

From Enterprise View or a custom view, select the database.
Right-click and select Edit, then Properties.
In Database Properties, select Statistics.
Expand the Blocks node to view the average clustering ratio.

Related Information

Database Properties Window—Statistics Tab
“Eliminating Fragmentation” in the Oracle Essbase Database Administrator's Guide

Related Commands

display database (MaxL) in the Oracle Essbase Technical Reference
getdbstats (ESSCMD) in the Oracle Essbase Technical Reference