Summarizes AWR wait event sample data.
GET {{baseUrl}}/managedDatabases/:managedDatabaseId/awrDbs/:awrDbId/awrDbWaitEvents?instNum=<string>&beginSnIdGreaterThanOrEqualTo=<integer>&endSnIdLessThanOrEqualTo=<integer>&timeGreaterThanOrEqualTo=<dateTime>&timeLessThanOrEqualTo=<dateTime>&name=<string>&name=<string>&sessionType=FOREGROUND&containerId=<integer>&page=<string>&limit=1000&sortBy=TIME_BEGIN&sortOrder=DESC
Summarizes the AWR wait event sample data for the specified database in the AWR. The event data is summarized based on the Time dimension for each event.
Request Params
Key | Datatype | Required | Description |
---|---|---|---|
instNum | string | The optional single value query parameter to filter the database instance number. | |
beginSnIdGreaterThanOrEqualTo | string | The optional greater than or equal to filter on the snapshot ID. | |
endSnIdLessThanOrEqualTo | string | The optional less than or equal to query parameter to filter the snapshot ID. | |
timeGreaterThanOrEqualTo | string | The optional greater than or equal to query parameter to filter the timestamp. | |
timeLessThanOrEqualTo | string | The optional less than or equal to query parameter to filter the timestamp. | |
name | string | The optional multiple value query parameter to filter the entity name. | |
name | string | The optional multiple value query parameter to filter the entity name. | |
sessionType | string | The optional query parameter to filter ASH activities by FOREGROUND or BACKGROUND. | |
containerId | string | The optional query parameter to filter the database container by an exact ID value. | |
Note that the database container ID can be retrieved from the following endpoint: | |||
/managedDatabases/{managedDatabaseId}/awrDbSnapshotRanges | |||
page | string | The page token representing the page from where the next set of paginated results | |
are retrieved. This is usually retrieved from a previous list call. | |||
limit | number | The maximum number of records returned in large paginated response. | |
sortBy | string | The option to sort the data within a time period. | |
sortOrder | string | The option to sort information in ascending (‘ASC’) or descending (‘DESC’) order. Descending order is the default order. |
HEADERS
Key | Datatype | Required | Description |
---|---|---|---|
opc-request-id | string | The client request ID for tracing. | |
opc-retry-token | string | A token that uniquely identifies a request so it can be retried in case of a timeout or | |
server error without risk of executing that same action again. Retry tokens expire after 24 | |||
hours, but can be invalidated before then due to conflicting operations. For example, if a resource | |||
has been deleted and purged from the system, then a retry of the original creation request | |||
might be rejected. | |||
opc-named-credential-id | string | The OCID of the Named Credential. | |
Accept | string |
RESPONSES
status: OK
{"name":"\u003cstring\u003e","awrResultType":"AWRDB_SYSSTAT_SET","dbQueryTimeInSecs":"\u003cdouble\u003e","queryKey":"\u003cstring\u003e","version":"\u003cstring\u003e","items":[{"name":"\u003cstring\u003e","avgWaitTimePerSec":"\u003cdouble\u003e","avgWaitTimePerWait":"\u003cdouble\u003e","snapshotId":"\u003cinteger\u003e","timeBegin":"\u003cdateTime\u003e","timeEnd":"\u003cdateTime\u003e","waitsPerSec":"\u003cdouble\u003e"},{"name":"\u003cstring\u003e","avgWaitTimePerSec":"\u003cdouble\u003e","avgWaitTimePerWait":"\u003cdouble\u003e","snapshotId":"\u003cinteger\u003e","timeBegin":"\u003cdateTime\u003e","timeEnd":"\u003cdateTime\u003e","waitsPerSec":"\u003cdouble\u003e"}]}