Get wait time summary from recent active session history records
get
/database/monitoring/waits_recent
Oracle Diagnostics Pack licence is required for this service. Group by sample_time and wait_class on GV$ACTIVE_SESSION_HISTORY for records with sample_time within the last 7 days. Note that time waited is in microseconds. 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
Wait time summary from active session history records within the last 7 days.
Root Schema : MonitoringWaitsRecentItem
Type:
object
A summary of time waited for each wait class in GV$ACTIVE_SESSION_HISTORY.
Show Source
Nested Schema : items
Type:
Show Source
object
-
sample_time: string
Time at which the sample was taken.
-
time_waited: integer
Amount of time (in microseconds) spent in waits from this wait class at the time of sampling.
-
wait_class: string
Wait class name of the event for which the session was waiting at the time of sampling.