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.
There's no request body 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
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 : items
Type:
Show Source
object
-
inst_id: integer
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: integer
Total number of active non-blocking sessions of this type.
-
number_of_active_blocking_sess: integer
Total number of active blocking sessions of this type.
-
number_of_active_sessions: integer
Total number of active sessions of this type.
-
number_of_inactive_sessions: integer
Total number of inactive sessions of this type.
-
number_of_sessions: integer
Total number of sessions of this type.
-
type: string
Session type.