Get all session limits
get
/database/monitoring/session_limits
Get all resource limits for sessions using GV$RESOURCE_LIMIT view. Since GV$RESOURCE_LIMIT exposes global level information, it can only be queried from CDB$ROOT or in a non-CDB database. 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
All session limits in the database.
Root Schema : MonitoringSessionLimitsItem
Type:
object
This object is used to monitor the consumption of session resources in the database. Since GV$RESOURCE_LIMIT exposes global/ CDB level information, it can only be queried from CDB$ROOT or in a non-CDB database. The list of attributes may vary depending on database version.
Show Source
-
con_id: integer
The ID of the container to which the data pertains.
-
current_utilization: integer
Number of (resources, locks, or processes) currently being used.
-
initial_allocation: string
Initial allocation. This will be equal to the value specified for the resource in the initialization parameter file (UNLIMITED for infinite allocation).
-
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.
-
limit_value: string
The maximum value of utilization that will be allowed.
-
links: array
links
-
max_utilization: integer
Maximum consumption of this resource since the last instance start-up.
-
resource_name: string
Name of the resource. This will always be session in this case.