Gets the optimizer statistics advisor task execution detailed report.
GET {{baseUrl}}/managedDatabases/:managedDatabaseId/optimizerStatisticsAdvisorExecutions/:executionName?taskName=<string>
Gets a comprehensive report of the Optimizer Statistics Advisor execution, which includes details of the Managed Database, findings, recommendations, rationale, and examples.
Request Params
Key | Datatype | Required | Description |
---|---|---|---|
taskName | string | (Required) The name of the optimizer statistics collection execution task. |
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
{"database":{"id":"\u003cstring\u003e","name":"\u003cstring\u003e","dbType":"DEDICATED","dbSubType":"CDB","dbDeploymentType":"ONPREMISE","dbVersion":"\u003cstring\u003e","compartmentId":"\u003cstring\u003e"},"executionName":"\u003cstring\u003e","report":{"summary":"\u003cstring\u003e","rules":[{"name":"\u003cstring\u003e","description":"\u003cstring\u003e","findings":[{"message":"\u003cstring\u003e","details":[{"operations":["\u003cstring\u003e","\u003cstring\u003e"],"schemas":[{"name":"\u003cstring\u003e","objects":["\u003cstring\u003e","\u003cstring\u003e"]},{"name":"\u003cstring\u003e","objects":["\u003cstring\u003e","\u003cstring\u003e"]}]},{"operations":["\u003cstring\u003e","\u003cstring\u003e"],"schemas":[{"name":"\u003cstring\u003e","objects":["\u003cstring\u003e","\u003cstring\u003e"]},{"name":"\u003cstring\u003e","objects":["\u003cstring\u003e","\u003cstring\u003e"]}]}],"recommendations":[{"message":"\u003cstring\u003e","example":{"lines":[{"comment":"\u003cstring\u003e","operation":"\u003cstring\u003e"},{"comment":"\u003cstring\u003e","operation":"\u003cstring\u003e"}]},"rationales":[{"message":"\u003cstring\u003e"},{"message":"\u003cstring\u003e"}]},{"message":"\u003cstring\u003e","example":{"lines":[{"comment":"\u003cstring\u003e","operation":"\u003cstring\u003e"},{"comment":"\u003cstring\u003e","operation":"\u003cstring\u003e"}]},"rationales":[{"message":"\u003cstring\u003e"},{"message":"\u003cstring\u003e"}]}]},{"message":"\u003cstring\u003e","details":[{"operations":["\u003cstring\u003e","\u003cstring\u003e"],"schemas":[{"name":"\u003cstring\u003e","objects":["\u003cstring\u003e","\u003cstring\u003e"]},{"name":"\u003cstring\u003e","objects":["\u003cstring\u003e","\u003cstring\u003e"]}]},{"operations":["\u003cstring\u003e","\u003cstring\u003e"],"schemas":[{"name":"\u003cstring\u003e","objects":["\u003cstring\u003e","\u003cstring\u003e"]},{"name":"\u003cstring\u003e","objects":["\u003cstring\u003e","\u003cstring\u003e"]}]}],"recommendations":[{"message":"\u003cstring\u003e","example":{"lines":[{"comment":"\u003cstring\u003e","operation":"\u003cstring\u003e"},{"comment":"\u003cstring\u003e","operation":"\u003cstring\u003e"}]},"rationales":[{"message":"\u003cstring\u003e"},{"message":"\u003cstring\u003e"}]},{"message":"\u003cstring\u003e","example":{"lines":[{"comment":"\u003cstring\u003e","operation":"\u003cstring\u003e"},{"comment":"\u003cstring\u003e","operation":"\u003cstring\u003e"}]},"rationales":[{"message":"\u003cstring\u003e"},{"message":"\u003cstring\u003e"}]}]}]},{"name":"\u003cstring\u003e","description":"\u003cstring\u003e","findings":[{"message":"\u003cstring\u003e","details":[{"operations":["\u003cstring\u003e","\u003cstring\u003e"],"schemas":[{"name":"\u003cstring\u003e","objects":["\u003cstring\u003e","\u003cstring\u003e"]},{"name":"\u003cstring\u003e","objects":["\u003cstring\u003e","\u003cstring\u003e"]}]},{"operations":["\u003cstring\u003e","\u003cstring\u003e"],"schemas":[{"name":"\u003cstring\u003e","objects":["\u003cstring\u003e","\u003cstring\u003e"]},{"name":"\u003cstring\u003e","objects":["\u003cstring\u003e","\u003cstring\u003e"]}]}],"recommendations":[{"message":"\u003cstring\u003e","example":{"lines":[{"comment":"\u003cstring\u003e","operation":"\u003cstring\u003e"},{"comment":"\u003cstring\u003e","operation":"\u003cstring\u003e"}]},"rationales":[{"message":"\u003cstring\u003e"},{"message":"\u003cstring\u003e"}]},{"message":"\u003cstring\u003e","example":{"lines":[{"comment":"\u003cstring\u003e","operation":"\u003cstring\u003e"},{"comment":"\u003cstring\u003e","operation":"\u003cstring\u003e"}]},"rationales":[{"message":"\u003cstring\u003e"},{"message":"\u003cstring\u003e"}]}]},{"message":"\u003cstring\u003e","details":[{"operations":["\u003cstring\u003e","\u003cstring\u003e"],"schemas":[{"name":"\u003cstring\u003e","objects":["\u003cstring\u003e","\u003cstring\u003e"]},{"name":"\u003cstring\u003e","objects":["\u003cstring\u003e","\u003cstring\u003e"]}]},{"operations":["\u003cstring\u003e","\u003cstring\u003e"],"schemas":[{"name":"\u003cstring\u003e","objects":["\u003cstring\u003e","\u003cstring\u003e"]},{"name":"\u003cstring\u003e","objects":["\u003cstring\u003e","\u003cstring\u003e"]}]}],"recommendations":[{"message":"\u003cstring\u003e","example":{"lines":[{"comment":"\u003cstring\u003e","operation":"\u003cstring\u003e"},{"comment":"\u003cstring\u003e","operation":"\u003cstring\u003e"}]},"rationales":[{"message":"\u003cstring\u003e"},{"message":"\u003cstring\u003e"}]},{"message":"\u003cstring\u003e","example":{"lines":[{"comment":"\u003cstring\u003e","operation":"\u003cstring\u003e"},{"comment":"\u003cstring\u003e","operation":"\u003cstring\u003e"}]},"rationales":[{"message":"\u003cstring\u003e"},{"message":"\u003cstring\u003e"}]}]}]}]},"status":"INTERRUPTED","taskName":"\u003cstring\u003e","timeEnd":"\u003cdateTime\u003e","timeStart":"\u003cdateTime\u003e","errorMessage":"\u003cstring\u003e","findings":"\u003cinteger\u003e","statusMessage":"\u003cstring\u003e"}