Lists the optimizer advisor task executions scan details and their findings count.
GET {{baseUrl}}/managedDatabases/:managedDatabaseId/optimizerStatisticsAdvisorExecutions?startTimeGreaterThanOrEqualTo=<string>&endTimeLessThanOrEqualTo=<string>
Lists the details of the Optimizer Statistics Advisor task executions, such as their duration, and the number of findings, if any. Optionally, you can specify a date-time range (of seven days) to obtain the list of executions that fall within the specified time range. If the date-time range is not specified, then the executions in the last seven days are listed.
Request Params
| Key | Datatype | Required | Description |
|---|---|---|---|
startTimeGreaterThanOrEqualTo | string | The start time of the time range to retrieve the optimizer statistics of a Managed Database | |
| in UTC in ISO-8601 format, which is "yyyy-MM-dd'T'hh:mm:ss.sss'Z'". | |||
endTimeLessThanOrEqualTo | string | The end time of the time range to retrieve the optimizer statistics of a Managed Database | |
| in UTC in ISO-8601 format, which is "yyyy-MM-dd'T'hh:mm:ss.sss'Z'". | |||
HEADERS
| Key | Datatype | Required | Description |
|---|---|---|---|
opc-request-id | string | The client request ID for tracing. | |
opc-named-credential-id | string | The OCID of the Named Credential. | |
Accept | string |
RESPONSES
status: OK
{"items":[{"taskName":"\u003cstring\u003e","executionName":"\u003cstring\u003e","timeStart":"\u003cdateTime\u003e","timeEnd":"\u003cdateTime\u003e","status":"FATAL_ERROR","errorMessage":"\u003cstring\u003e","findings":"\u003cinteger\u003e","statusMessage":"\u003cstring\u003e"},{"taskName":"\u003cstring\u003e","executionName":"\u003cstring\u003e","timeStart":"\u003cdateTime\u003e","timeEnd":"\u003cdateTime\u003e","status":"COMPLETED","errorMessage":"\u003cstring\u003e","findings":"\u003cinteger\u003e","statusMessage":"\u003cstring\u003e"}]}