Get count of different session types
get
/database/monitoring/session_summaries/by_type
Group by session type on GV$SESSION. A client requires SQL Administrator role to invoke this service.
Request
There are no request parameters for this operation.
Back to TopResponse
Supported Media Types
- application/json
200 Response
Summary of different session types in the database.
Root Schema : MonitoringSessionTypeSummariesItem
Type:
object
Title:
MonitoringSessionTypeSummariesItem
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).
Show Source
Nested Schema : Item
Type:
object
Title:
Show Source
Item
-
inst_id(optional):
integer(int32)
Oracle Real Application Clusters instance number for which this data relates to. In a non-RAC database this number will be 1.
-
number_of_act_non_blocking_ses(optional):
integer(int32)
Total number of active non-blocking sessions of this type.
-
number_of_active_blocking_sess(optional):
integer(int32)
Total number of active blocking sessions of this type.
-
number_of_active_sessions(optional):
integer(int32)
Total number of active sessions of this type.
-
number_of_inactive_sessions(optional):
integer(int32)
Total number of inactive sessions of this type.
-
number_of_sessions(optional):
integer(int32)
Total number of sessions of this type.
-
type(optional):
string
Session type.