ESS_DBSTATS_T

This database statistics structure gets run-time statistical information about a specific database. Fields in this structure cannot be modified using the API. See also the ESS_DBSTATE_T structure, which contains additional database state parameters that can be modified, and the ESS_DBINFO_T structure. The fields are:

typedef struct ESS_DBSTATS_T
{
   ESS_USHORT_T      IndexType;                 
   ESS_ULONG_T       nDims;                     
   ESS_ULONG_T       DeclaredBlockSize;         
   ESS_ULONG_T       ActualBlockSize;           
   ESS_DOUBLE_T      DeclaredMaxBlocks;         
   ESS_DOUBLE_T      ActualMaxBlocks;           
   ESS_DOUBLE_T      NonMissingLeafBlocks;      
   ESS_DOUBLE_T      NonMissingNonLeafBlocks;   
   ESS_DOUBLE_T      NonMissingBlocks;          
   ESS_DOUBLE_T      PagedOutBlocks;            
   ESS_DOUBLE_T      PagedInBlocks;             
   ESS_DOUBLE_T      InMemCompBlocks;           
   ESS_DOUBLE_T      TotalBlocks;               
   ESS_DOUBLE_T      NonExclusiveLockCount;     
   ESS_DOUBLE_T      ExclusiveLockCount;        
   ESS_DOUBLE_T      TotMemPagedInBlocks;       
   ESS_DOUBLE_T      TotMemBlocks;              
   ESS_DOUBLE_T      TotMemIndex;               
   ESS_DOUBLE_T      TotMemInMemCompBlocks;     
   ESS_DOUBLE_T      BlockDensity;              
   ESS_DOUBLE_T      SparseDensity;             
   ESS_DOUBLE_T      CompressionRatio;          
   ESS_DOUBLE_T      ClusterRatio;            
   ESS_DIMSTATS_T    DimStatsAry[1];
} ESS_DBSTATS_T, *ESS_PDBSTATS_T, **ESS_PPDBSTATS_T;
Data Type FieldDescription
ESS_USHORT_T IndexType The database index type (array or tree). This field can contain the following values:

ESS_INDEXTYPE_ARRAY
ESS_INDEXTYPE_AVL

ESS_ULONG_T nDims The number of dimensions in database.
ESS_ULONG_T DeclaredBlock
Size
The declared data block size.
ESS_ULONG_T ActualBlock
Size
The actual data block size
ESS_DOUBLE_T DeclaredMax
Blocks
The declared maximum number of blocks in the database.
ESS_DOUBLE_T ActualMaxBlocks The actual maximum number of blocks in the database.
ESS_DOUBLE_T NonMissingLeaf
Blocks
The number of non-missing leaf (lowest level) blocks in the database.
ESS_DOUBLE_T NonMissing
NonLeafBlocks
The number of non-missing, non-leaf (upper level) blocks in the database.
ESS_DOUBLE_T NonMissingBlocks Obsolete. Returns zero.
ESS_DOUBLE_T PagedOutBlocks The number of database blocks currently paged out to disk.
ESS_DOUBLE_T PagedInBlocks The total number of database blocks currently paged into memory.
ESS_DOUBLE_T InMemComp
Blocks
The number of database blocks currently paged into compressed memory.
ESS_DOUBLE_T TotalBlocks Total number of existing data blocks (not the maximum).
ESS_DOUBLE_T NonExclusiveLockCount The number of database blocks currently non-exclusively locked.
ESS_DOUBLE_T ExclusiveLock
Count
The number of database blocks currently exclusively locked.
ESS_DOUBLE_T TotMemPagedIn-Blocks The total memory used for all paged-in (uncompressed) database blocks
ESS_DOUBLE_T TotMemBlocks The total memory used for all database blocks.
ESS_DOUBLE_T TotMemIndex The total memory used for the database index.
ESS_DOUBLE_T TotMemInMem
CompBlocks
The total memory used for database blocks currently paged into compressed memory.
ESS_DOUBLE_T BlockDensity The average database block density (calculated using all currently loaded blocks).
ESS_DOUBLE_T SparseDensity Average density of the sparse dimensions in the database.
ESS_DOUBLE_TCompression
Ratio
Average data block compression ratio on the disk.
ESS_DOUBLE_T ClusterRatio A measure of the fragmentation of the page file. A value close to 1 indicates the degree of fragmentation is low. A value close to zero indicates a high degree of fragmentation that could affect calculation and query performance.
ESS_DIMSTATS_T DimStatsAry [1] Dynamic array (with nDim elements) of Dimension Statistical Structures, of type ESS_DIMSTATS_T. See the structure definition.