Returns information about dimensions and data blocks for the selected database.
Syntax
GETDBSTATS
Notes
For information about how to use the Average Fragmentation Quotient, see the Oracle Essbase Database Administrator's Guide section about monitoring performance.
Example
GETDBSTATS;
Returns:
-------Statistics of sample:basic ------- Dimension Name Type Declared Size Actual Size =================================================================== Year DENSE 19 12 Measures DENSE 17 8 Product SPARSE 22 19 Market SPARSE 25 25 Scenario DENSE 5 2 Caffeinated SPARSE 3 3 Ounces SPARSE 5 5 Pkg Type SPARSE 3 3 Population SPARSE 15 15 Intro Date SPARSE 8 8 Number of dimensions : 10 Declared Block Size : 1615 Actual Block Size : 192 Declared Maximum Blocks : 550 Actual Maximum Blocks : 475 Number of Non Missing Leaf Blocks : 177 Number of Non Missing Non Leaf Blocks : 197 Number of Total Blocks : 374 Index Type : B+ TREE Average Block Density : 93.75 Average Sparse Density : 78.73684 Block Compression Ratio : 0.9552239 Average Clustering Ratio : 1 Average Fragmentation Quotient : 0.01238265 Free Space is Recoverable : false Estimated Bytes of Recoverable Free Space : 0
See Also