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. |
“Eliminating Fragmentation” in the Oracle Essbase Database Administrator's Guide
display database (MaxL) in the Oracle Essbase Technical Reference
getdbstats (ESSCMD) in the Oracle Essbase Technical Reference