ルート・スキーマ: MonitoringSessionTypeSummariesItem
タイプ: object
このオブジェクトは、GV$SESSIONからのデータを使用して、様々なセッション・タイプ(BACKGROUNDおよびUSER)にわたり集計された、様々な状態のセッションの数のサマリーを表します。
ソースの表示
{
"type":"object",
"description":"Using data from GV$SESSION this object represents a summary of the number of sessions in different states aggregated across different session types (BACKGROUND and USER).",
"properties":{
"items":{
"type":"array",
"items":{
"type":"object",
"properties":{
"inst_id":{
"type":"integer",
"description":"Oracle Real Application Clusters instance number for which this data relates to. In a non-RAC database this number will be 1."
},
"type":{
"type":"string",
"description":"Session type."
},
"number_of_sessions":{
"type":"integer",
"description":"Total number of sessions of this type."
},
"number_of_active_sessions":{
"type":"integer",
"description":"Total number of active sessions of this type."
},
"number_of_inactive_sessions":{
"type":"integer",
"description":"Total number of inactive sessions of this type."
},
"number_of_active_blocking_sess":{
"type":"integer",
"description":"Total number of active blocking sessions of this type."
},
"number_of_act_non_blocking_ses":{
"type":"integer",
"description":"Total number of active non-blocking sessions of this type."
}
}
}
},
"links":{
"type":"array",
"items":{
"$ref":"#/definitions/LinkRelation"
}
}
}
}
ネストされたスキーマ: items
タイプ: array
ソースの表示
{
"type":"array",
"items":{
"type":"object",
"properties":{
"inst_id":{
"type":"integer",
"description":"Oracle Real Application Clusters instance number for which this data relates to. In a non-RAC database this number will be 1."
},
"type":{
"type":"string",
"description":"Session type."
},
"number_of_sessions":{
"type":"integer",
"description":"Total number of sessions of this type."
},
"number_of_active_sessions":{
"type":"integer",
"description":"Total number of active sessions of this type."
},
"number_of_inactive_sessions":{
"type":"integer",
"description":"Total number of inactive sessions of this type."
},
"number_of_active_blocking_sess":{
"type":"integer",
"description":"Total number of active blocking sessions of this type."
},
"number_of_act_non_blocking_ses":{
"type":"integer",
"description":"Total number of active non-blocking sessions of this type."
}
}
}
}
ネストされたスキーマ: links
タイプ: array
ソースの表示
{
"type":"array",
"items":{
"$ref":"#/definitions/LinkRelation"
}
}
ネストされたスキーマ: items
タイプ: object
ソースの表示
{
"type":"object",
"properties":{
"inst_id":{
"type":"integer",
"description":"Oracle Real Application Clusters instance number for which this data relates to. In a non-RAC database this number will be 1."
},
"type":{
"type":"string",
"description":"Session type."
},
"number_of_sessions":{
"type":"integer",
"description":"Total number of sessions of this type."
},
"number_of_active_sessions":{
"type":"integer",
"description":"Total number of active sessions of this type."
},
"number_of_inactive_sessions":{
"type":"integer",
"description":"Total number of inactive sessions of this type."
},
"number_of_active_blocking_sess":{
"type":"integer",
"description":"Total number of active blocking sessions of this type."
},
"number_of_act_non_blocking_ses":{
"type":"integer",
"description":"Total number of active non-blocking sessions of this type."
}
}
}
ネストされたスキーマ: LinkRelation
タイプ: object
ソースの表示
{
"type":"object",
"properties":{
"rel":{
"type":"string"
},
"href":{
"type":"string"
}
},
"required":[
"rel",
"href"
]
}