ルート・スキーマ: MonitoringWaitClassMetricsItem
タイプ: object
このオブジェクトは、GV$WAITCLASSMETRICビューおよびGV$SYSTEM_WAIT_CLASSビューからのデータを結合して、直近の60秒間隔での待機クラスのメトリック値を表します。
ソースの表示
{
"type":"object",
"description":"This object combines data from GV$WAITCLASSMETRIC and GV$SYSTEM_WAIT_CLASS views to represent metric values of wait classes for the most recent 60-second interval.",
"properties":{
"items":{
"type":"array",
"items":{
"type":"object",
"properties":{
"begin_time":{
"type":"string",
"description":"Begin time of the interval."
},
"end_time":{
"type":"string",
"description":"End time of the interval."
},
"intsize_csec":{
"type":"integer",
"description":"Interval size (in hundredths of a second)."
},
"average_waiter_count":{
"type":"integer",
"description":"Average waiter count."
},
"dbtime_in_wait":{
"type":"integer",
"description":"Percent of database time spent in the wait."
},
"wait_count":{
"type":"integer",
"description":"Number of times waited."
},
"wait_count_fg":{
"type":"integer",
"description":"Number of times foreground processes waited."
},
"wait_class_id":{
"type":"integer",
"description":"Identifier of the wait class."
},
"wait_class#":{
"type":"integer",
"description":"Number of the wait class."
},
"wait_class":{
"type":"string",
"description":"Name of the wait class."
},
"total_waits":{
"type":"integer",
"description":"Number of times waits of the class occurred."
},
"time_waited":{
"type":"integer",
"description":"Amount of time (in hundredths of a second) spent in the wait by all sessions in the instance."
},
"total_waits_fg":{
"type":"integer",
"description":"Number of times waits from this wait class occurred in foreground sessions."
},
"time_waited_fg":{
"type":"integer",
"description":"Amount of time (in hundredths of a second) spent in waits from this wait class in foreground sessions."
},
"con_id":{
"type":"integer",
"description":"The ID of the container to which the data pertains."
}
}
}
},
"links":{
"type":"array",
"items":{
"$ref":"#/definitions/LinkRelation"
}
}
}
}
ネストされたスキーマ: items
タイプ: array
ソースの表示
{
"type":"array",
"items":{
"type":"object",
"properties":{
"begin_time":{
"type":"string",
"description":"Begin time of the interval."
},
"end_time":{
"type":"string",
"description":"End time of the interval."
},
"intsize_csec":{
"type":"integer",
"description":"Interval size (in hundredths of a second)."
},
"average_waiter_count":{
"type":"integer",
"description":"Average waiter count."
},
"dbtime_in_wait":{
"type":"integer",
"description":"Percent of database time spent in the wait."
},
"wait_count":{
"type":"integer",
"description":"Number of times waited."
},
"wait_count_fg":{
"type":"integer",
"description":"Number of times foreground processes waited."
},
"wait_class_id":{
"type":"integer",
"description":"Identifier of the wait class."
},
"wait_class#":{
"type":"integer",
"description":"Number of the wait class."
},
"wait_class":{
"type":"string",
"description":"Name of the wait class."
},
"total_waits":{
"type":"integer",
"description":"Number of times waits of the class occurred."
},
"time_waited":{
"type":"integer",
"description":"Amount of time (in hundredths of a second) spent in the wait by all sessions in the instance."
},
"total_waits_fg":{
"type":"integer",
"description":"Number of times waits from this wait class occurred in foreground sessions."
},
"time_waited_fg":{
"type":"integer",
"description":"Amount of time (in hundredths of a second) spent in waits from this wait class in foreground sessions."
},
"con_id":{
"type":"integer",
"description":"The ID of the container to which the data pertains."
}
}
}
}
ネストされたスキーマ: links
タイプ: array
ソースの表示
{
"type":"array",
"items":{
"$ref":"#/definitions/LinkRelation"
}
}
ネストされたスキーマ: items
タイプ: object
ソースの表示
{
"type":"object",
"properties":{
"begin_time":{
"type":"string",
"description":"Begin time of the interval."
},
"end_time":{
"type":"string",
"description":"End time of the interval."
},
"intsize_csec":{
"type":"integer",
"description":"Interval size (in hundredths of a second)."
},
"average_waiter_count":{
"type":"integer",
"description":"Average waiter count."
},
"dbtime_in_wait":{
"type":"integer",
"description":"Percent of database time spent in the wait."
},
"wait_count":{
"type":"integer",
"description":"Number of times waited."
},
"wait_count_fg":{
"type":"integer",
"description":"Number of times foreground processes waited."
},
"wait_class_id":{
"type":"integer",
"description":"Identifier of the wait class."
},
"wait_class#":{
"type":"integer",
"description":"Number of the wait class."
},
"wait_class":{
"type":"string",
"description":"Name of the wait class."
},
"total_waits":{
"type":"integer",
"description":"Number of times waits of the class occurred."
},
"time_waited":{
"type":"integer",
"description":"Amount of time (in hundredths of a second) spent in the wait by all sessions in the instance."
},
"total_waits_fg":{
"type":"integer",
"description":"Number of times waits from this wait class occurred in foreground sessions."
},
"time_waited_fg":{
"type":"integer",
"description":"Amount of time (in hundredths of a second) spent in waits from this wait class in foreground sessions."
},
"con_id":{
"type":"integer",
"description":"The ID of the container to which the data pertains."
}
}
}
ネストされたスキーマ: LinkRelation
タイプ: object
ソースの表示
{
"type":"object",
"properties":{
"rel":{
"type":"string"
},
"href":{
"type":"string"
}
},
"required":[
"rel",
"href"
]
}