Note: | The average clustering ratio database statistic is an approximate indication of the ordering in which data blocks are laid out in data (.pag) files. The maximum value of 1 indicates that the blocks are laid out in block key order within data files. The reported value of the clustering ratio may be less than 1, even upon restructure, due to the scalability enhancements as well as support for parallel operations. This statistic does not apply to aggregate storage databases. |
“Eliminating and Measuring 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