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.
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
Title:
MonitoringWaitsRecentItem
A summary of time waited for each wait class in GV$ACTIVE_SESSION_HISTORY.
Show Source
Nested Schema : Item1
Type:
object
Title:
Show Source
Item1
-
sample_time(optional):
string
Time at which the sample was taken.
-
time_waited(optional):
integer(int32)
Amount of time (in microseconds) spent in waits from this wait class at the time of sampling.
-
wait_class(optional):
string
Wait class name of the event for which the session was waiting at the time of sampling.