Show Source

• 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"
        }
    }
}