Summarizes AWR snapshot ranges.
GET {{baseUrl}}/managedDatabases/:managedDatabaseId/awrDbSnapshotRanges?name=<string>&timeGreaterThanOrEqualTo=<dateTime>&timeLessThanOrEqualTo=<dateTime>&page=<string>&limit=10&sortBy=END_INTERVAL_TIME&sortOrder=DESC
Summarizes the AWR snapshot ranges that contain continuous snapshots, for the specified Managed Database.
Request Params
Key | Datatype | Required | Description |
---|---|---|---|
name | string | The optional single value query parameter to filter the entity name. | |
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. | |
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 the paginated response. | |
sortBy | string | The option to sort the AWR summary data. | |
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_METRICS_SET","dbQueryTimeInSecs":"\u003cdouble\u003e","queryKey":"\u003cstring\u003e","version":"\u003cstring\u003e","items":[{"awrDbId":"\u003cstring\u003e","dbName":"\u003cstring\u003e","containerId":"\u003cinteger\u003e","dbVersion":"\u003cstring\u003e","firstSnapshotId":"\u003cinteger\u003e","instanceList":["\u003cinteger\u003e","\u003cinteger\u003e"],"latestSnapshotId":"\u003cinteger\u003e","snapshotCount":"\u003clong\u003e","snapshotIntervalInMin":"\u003cinteger\u003e","snapshotTimezone":"\u003cstring\u003e","timeDbStartup":"\u003cdateTime\u003e","timeFirstSnapshotBegin":"\u003cdateTime\u003e","timeLatestSnapshotEnd":"\u003cdateTime\u003e"},{"awrDbId":"\u003cstring\u003e","dbName":"\u003cstring\u003e","containerId":"\u003cinteger\u003e","dbVersion":"\u003cstring\u003e","firstSnapshotId":"\u003cinteger\u003e","instanceList":["\u003cinteger\u003e","\u003cinteger\u003e"],"latestSnapshotId":"\u003cinteger\u003e","snapshotCount":"\u003clong\u003e","snapshotIntervalInMin":"\u003cinteger\u003e","snapshotTimezone":"\u003cstring\u003e","timeDbStartup":"\u003cdateTime\u003e","timeFirstSnapshotBegin":"\u003cdateTime\u003e","timeLatestSnapshotEnd":"\u003cdateTime\u003e"}]}