Returns detailed statistics for the currently selected database.
GETDBSTATS
This command returns information about dimensions and data blocks for the
currently selected database.
For information about how to use the Average Fragmentation Quotient, see the Database Administrator's Guide section about monitoring performance.
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
GETDBACTIVE
GETDBINFO
GETDBSTATE
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |