• general: object GeneralStatistics
• links: array links
• runtime: object RuntimeStatistics
• storage: object StorageStatistics

{
    "type":"object",
    "properties":{
        "general":{
            "$ref":"#/definitions/GeneralStatistics"
        },
        "storage":{
            "$ref":"#/definitions/StorageStatistics"
        },
        "runtime":{
            "$ref":"#/definitions/RuntimeStatistics"
        },
        "links":{
            "type":"array",
            "items":{
                "$ref":"#/definitions/Link"
            }
        }
    },
    "xml":{
        "name":"statistics"
    }
}

• databaseElapsedTime: string
• databaseStartTime: integer(int64)
• loadStatus: string
• numberOfConnections: integer(int32)
• numberOfDimensions: integer(int32)

{
    "type":"object",
    "properties":{
        "databaseStartTime":{
            "type":"integer",
            "format":"int64"
        },
        "databaseElapsedTime":{
            "type":"string"
        },
        "numberOfConnections":{
            "type":"integer",
            "format":"int32"
        },
        "numberOfDimensions":{
            "type":"integer",
            "format":"int32"
        },
        "loadStatus":{
            "type":"string"
        }
    }
}

• Array of: object Link

{
    "type":"array",
    "items":{
        "$ref":"#/definitions/Link"
    }
}

• cacheHitRatio: number(double)

  Ratio of the number of requests answered from aggregate storage cache as opposed to from the hard disk. May not be accurate when parallel data load or parallel calculation operations are in use.

• currentCacheSize: number(double)

  The current size of the aggregate storage cache. See also currentCacheSizeLimit.

• currentCacheSizeLimit: number(double)

  The maximum size (in kilobytes) to which the aggregate storage cache may grow.

• diskSpaceAllocatedForData: number(double)

  For an aggregate storage cube, total space used by all disk files in the default tablespace.

• diskSpaceUsedByData: number(double)

  For an aggregate storage cube, total space actually in use within the disk files in the default tablespace (some space within files may be free).

• hitRatioOnDataCache: number(double)
• hitRatioOnDataFileCache: number(double)
• hitRatioOnIndexCache: number(double)
• numberOfDataBlockReads: number(double)
• numberOfDataBlockWrites: number(double)
• numberOfIndexPageReads: number(double)
• numberOfIndexPageWrites: number(double)
• pageReadsSinceLastStartup: number(double)

  For an aggregate storage cube, number of data pages read from disk since the last time the application was started.

• pageSize: number(double)

  For an aggregate storage cube, size of the data page in kilobytes.

• pageWritesSinceLastStartup: number(double)

  For an aggregate storage cube, number of data pages written to disk since the last time the application was started.

• temporaryDiskSpaceAllocated: number(double)

  For an aggregate storage cube, total space used by all disk files in the temp tablespace.

• temporaryDiskSpaceUsed: number(double)

  For an aggregate storage cube, total space actually in use within the disk files in the temp tablespace (some space within files may be free).

{
    "type":"object",
    "properties":{
        "cacheHitRatio":{
            "type":"number",
            "description":"<p>Ratio of the number of requests answered from aggregate storage cache as opposed to from the hard disk. May not be accurate when parallel data load or parallel calculation operations are in use.</p>",
            "format":"double"
        },
        "currentCacheSize":{
            "type":"number",
            "description":"<p>The current size of the aggregate storage cache. See also currentCacheSizeLimit.</p>",
            "format":"double"
        },
        "currentCacheSizeLimit":{
            "type":"number",
            "description":"<p>The maximum size (in kilobytes) to which the aggregate storage cache may grow.</p>",
            "format":"double"
        },
        "pageReadsSinceLastStartup":{
            "type":"number",
            "description":"<p>For an aggregate storage cube, number of data pages read from disk since the last time the application was started.</p>",
            "format":"double"
        },
        "pageWritesSinceLastStartup":{
            "type":"number",
            "description":"<p>For an aggregate storage cube, number of data pages written to disk since the last time the application was started.</p>",
            "format":"double"
        },
        "pageSize":{
            "type":"number",
            "description":"<p>For an aggregate storage cube, size of the data page in kilobytes.</p>",
            "format":"double"
        },
        "diskSpaceAllocatedForData":{
            "type":"number",
            "description":"<p>For an aggregate storage cube, total space used by all disk files in the default tablespace.</p>",
            "format":"double"
        },
        "diskSpaceUsedByData":{
            "type":"number",
            "description":"<p>For an aggregate storage cube, total space actually in use within the disk files in the default tablespace (some space within files may be free).</p>",
            "format":"double"
        },
        "temporaryDiskSpaceAllocated":{
            "type":"number",
            "description":"<p>For an aggregate storage cube, total space used by all disk files in the temp tablespace.</p>",
            "format":"double"
        },
        "temporaryDiskSpaceUsed":{
            "type":"number",
            "description":"<p>For an aggregate storage cube, total space actually in use within the disk files in the temp tablespace (some space within files may be free).</p>",
            "format":"double"
        },
        "hitRatioOnIndexCache":{
            "type":"number",
            "format":"double"
        },
        "hitRatioOnDataCache":{
            "type":"number",
            "format":"double"
        },
        "numberOfIndexPageReads":{
            "type":"number",
            "format":"double"
        },
        "numberOfIndexPageWrites":{
            "type":"number",
            "format":"double"
        },
        "numberOfDataBlockReads":{
            "type":"number",
            "format":"double"
        },
        "numberOfDataBlockWrites":{
            "type":"number",
            "format":"double"
        },
        "hitRatioOnDataFileCache":{
            "type":"number",
            "format":"double"
        }
    }
}

• aggregateDataSize: integer(int32)

  For aggregate storage cubes, the total disk space occupied by aggregate cells

• averageClusteringRatio: number(double)

  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.

• blockDensity: number(double)

  The average block density (calculated using all currently loaded blocks)

• blockSize: integer(int32)
• compressionRatio: number(double)

  Average data block compression ratio

• costOfQueryingIncrementalData: number(double)

  For aggregate storage cubes, the average percentage of query time spent processing incremental data slices. This is useful in deciding when slices should be merged together to improve query performance.

• dimensions: array dimensions
• existingLevelZeroBlocks: number(double)

  The number of non-missing leaf (lowest level) blocks in the cube

• existingUpperLevelBlocks: number(double)

  The number of non-missing, non-leaf (upper level) blocks in the cube

• indexFileSize: integer(int64)
• inputLevelDataSize: integer(int32)

  For aggregate storage cubes, the total disk space used by input-level data

• maxKeyLengthBits: integer(int32)

  For aggregate storage cubes, the sum of all the bits used by each dimension. For example, there are 20 bits in the key used for dimensions, and the first 4 are used by Year.

• maxKeyLengthBytes: integer(int32)

  For aggregate storage cubes, how many bytes the key uses per cell

• numberOfAggregateCells: integer(int32)

  For aggregate storage cubes, the number of cells stored in aggregate views

• numberOfAggregateViews: integer(int32)

  For aggregate storage cubes, the number of aggregate views, including those automatically built on incremental slices

• numberOfExistingBlocks: number(double)

  Total number of existing data blocks (not the maximum)

• numberOfIncrementalAggregateCells: integer(int32)

  For aggregate storage cubes, the number of cells stored in the incremental slices' aggregate views

• numberOfIncrementalDataSlices: integer(int32)

  For aggregate storage cubes, the number of data slices resulting from incremental data loads

• numberOfIncrementalInputCells: integer(int32)

  For aggregate storage cubes, the number of level-0 cells in the incremental data slices

• numberOfInputLevelCells: integer(int32)

  For aggregate storage cubes, the number of existing level-0 cells in the database, including incremental slices

• pageFileSize: integer(int64)
• percentageOfMaximumBlocksExisting: number(double)
• potentialNumberOfBlocks: number(double)

{
    "type":"object",
    "properties":{
        "dimensions":{
            "type":"array",
            "items":{
                "$ref":"#/definitions/StatisticsDimensions"
            }
        },
        "maxKeyLengthBits":{
            "type":"integer",
            "description":"<p>For aggregate storage cubes, the sum of all the bits used by each dimension. For example, there are 20 bits in the key used for dimensions, and the first 4 are used by Year.</p>",
            "format":"int32"
        },
        "maxKeyLengthBytes":{
            "type":"integer",
            "description":"<p>For aggregate storage cubes, how many bytes the key uses per cell</p>",
            "format":"int32"
        },
        "numberOfInputLevelCells":{
            "type":"integer",
            "description":"<p>For aggregate storage cubes, the number of existing level-0 cells in the database, including incremental slices</p>",
            "format":"int32"
        },
        "numberOfIncrementalDataSlices":{
            "type":"integer",
            "description":"<p>For aggregate storage cubes, the number of data slices resulting from incremental data loads</p>",
            "format":"int32"
        },
        "numberOfIncrementalInputCells":{
            "type":"integer",
            "description":"<p>For aggregate storage cubes, the number of level-0 cells in the incremental data slices</p>",
            "format":"int32"
        },
        "numberOfAggregateViews":{
            "type":"integer",
            "description":"<p>For aggregate storage cubes, the number of aggregate views, including those automatically built on incremental slices</p>",
            "format":"int32"
        },
        "numberOfAggregateCells":{
            "type":"integer",
            "description":"<p>For aggregate storage cubes, the number of cells stored in aggregate views</p>",
            "format":"int32"
        },
        "numberOfIncrementalAggregateCells":{
            "type":"integer",
            "description":"<p>For aggregate storage cubes, the number of cells stored in the incremental slices' aggregate views</p>",
            "format":"int32"
        },
        "costOfQueryingIncrementalData":{
            "type":"number",
            "description":"<p>For aggregate storage cubes, the average percentage of query time spent processing incremental data slices. This is useful in deciding when slices should be merged together to improve query performance.</p>",
            "format":"double"
        },
        "inputLevelDataSize":{
            "type":"integer",
            "description":"<p>For aggregate storage cubes, the total disk space used by input-level data</p>",
            "format":"int32"
        },
        "aggregateDataSize":{
            "type":"integer",
            "description":"<p>For aggregate storage cubes, the total disk space occupied by aggregate cells</p>",
            "format":"int32"
        },
        "numberOfExistingBlocks":{
            "type":"number",
            "description":"<p>Total number of existing data blocks (not the maximum)</p>",
            "format":"double"
        },
        "blockSize":{
            "type":"integer",
            "format":"int32"
        },
        "potentialNumberOfBlocks":{
            "type":"number",
            "format":"double"
        },
        "existingLevelZeroBlocks":{
            "type":"number",
            "description":"<p>The number of non-missing leaf (lowest level) blocks in the cube</p>",
            "format":"double"
        },
        "existingUpperLevelBlocks":{
            "type":"number",
            "description":"<p>The number of non-missing, non-leaf (upper level) blocks in the cube</p>",
            "format":"double"
        },
        "blockDensity":{
            "type":"number",
            "description":"<p>The average block density (calculated using all currently loaded blocks)</p>",
            "format":"double"
        },
        "percentageOfMaximumBlocksExisting":{
            "type":"number",
            "format":"double"
        },
        "compressionRatio":{
            "type":"number",
            "description":"<p>Average data block compression ratio</p>",
            "format":"double"
        },
        "averageClusteringRatio":{
            "type":"number",
            "description":"<p>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.</p>",
            "format":"double"
        },
        "pageFileSize":{
            "type":"integer",
            "format":"int64"
        },
        "indexFileSize":{
            "type":"integer",
            "format":"int64"
        }
    }
}

• href: string
• method: string
• rel: string
• type: string

{
    "type":"object",
    "properties":{
        "rel":{
            "type":"string"
        },
        "href":{
            "type":"string"
        },
        "method":{
            "type":"string"
        },
        "type":{
            "type":"string"
        }
    }
}

• Array of: object StatisticsDimensions

{
    "type":"array",
    "items":{
        "$ref":"#/definitions/StatisticsDimensions"
    }
}

• bits: number(double)
• levels: string
• name: string

{
    "type":"object",
    "properties":{
        "name":{
            "type":"string"
        },
        "levels":{
            "type":"string"
        },
        "bits":{
            "type":"number",
            "format":"double"
        }
    }
}