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

KeyDatatypeRequiredDescription
taskNamestring(Required) The name of the optimizer statistics collection execution task.

HEADERS

KeyDatatypeRequiredDescription
opc-request-idstringThe client request ID for tracing.
opc-named-credential-idstringThe OCID of the Named Credential.
Acceptstring

RESPONSES

status: OK

{&quot;database&quot;:{&quot;id&quot;:&quot;\u003cstring\u003e&quot;,&quot;name&quot;:&quot;\u003cstring\u003e&quot;,&quot;dbType&quot;:&quot;DEDICATED&quot;,&quot;dbSubType&quot;:&quot;CDB&quot;,&quot;dbDeploymentType&quot;:&quot;ONPREMISE&quot;,&quot;dbVersion&quot;:&quot;\u003cstring\u003e&quot;,&quot;compartmentId&quot;:&quot;\u003cstring\u003e&quot;},&quot;executionName&quot;:&quot;\u003cstring\u003e&quot;,&quot;report&quot;:{&quot;summary&quot;:&quot;\u003cstring\u003e&quot;,&quot;rules&quot;:[{&quot;name&quot;:&quot;\u003cstring\u003e&quot;,&quot;description&quot;:&quot;\u003cstring\u003e&quot;,&quot;findings&quot;:[{&quot;message&quot;:&quot;\u003cstring\u003e&quot;,&quot;details&quot;:[{&quot;operations&quot;:[&quot;\u003cstring\u003e&quot;,&quot;\u003cstring\u003e&quot;],&quot;schemas&quot;:[{&quot;name&quot;:&quot;\u003cstring\u003e&quot;,&quot;objects&quot;:[&quot;\u003cstring\u003e&quot;,&quot;\u003cstring\u003e&quot;]},{&quot;name&quot;:&quot;\u003cstring\u003e&quot;,&quot;objects&quot;:[&quot;\u003cstring\u003e&quot;,&quot;\u003cstring\u003e&quot;]}]},{&quot;operations&quot;:[&quot;\u003cstring\u003e&quot;,&quot;\u003cstring\u003e&quot;],&quot;schemas&quot;:[{&quot;name&quot;:&quot;\u003cstring\u003e&quot;,&quot;objects&quot;:[&quot;\u003cstring\u003e&quot;,&quot;\u003cstring\u003e&quot;]},{&quot;name&quot;:&quot;\u003cstring\u003e&quot;,&quot;objects&quot;:[&quot;\u003cstring\u003e&quot;,&quot;\u003cstring\u003e&quot;]}]}],&quot;recommendations&quot;:[{&quot;message&quot;:&quot;\u003cstring\u003e&quot;,&quot;example&quot;:{&quot;lines&quot;:[{&quot;comment&quot;:&quot;\u003cstring\u003e&quot;,&quot;operation&quot;:&quot;\u003cstring\u003e&quot;},{&quot;comment&quot;:&quot;\u003cstring\u003e&quot;,&quot;operation&quot;:&quot;\u003cstring\u003e&quot;}]},&quot;rationales&quot;:[{&quot;message&quot;:&quot;\u003cstring\u003e&quot;},{&quot;message&quot;:&quot;\u003cstring\u003e&quot;}]},{&quot;message&quot;:&quot;\u003cstring\u003e&quot;,&quot;example&quot;:{&quot;lines&quot;:[{&quot;comment&quot;:&quot;\u003cstring\u003e&quot;,&quot;operation&quot;:&quot;\u003cstring\u003e&quot;},{&quot;comment&quot;:&quot;\u003cstring\u003e&quot;,&quot;operation&quot;:&quot;\u003cstring\u003e&quot;}]},&quot;rationales&quot;:[{&quot;message&quot;:&quot;\u003cstring\u003e&quot;},{&quot;message&quot;:&quot;\u003cstring\u003e&quot;}]}]},{&quot;message&quot;:&quot;\u003cstring\u003e&quot;,&quot;details&quot;:[{&quot;operations&quot;:[&quot;\u003cstring\u003e&quot;,&quot;\u003cstring\u003e&quot;],&quot;schemas&quot;:[{&quot;name&quot;:&quot;\u003cstring\u003e&quot;,&quot;objects&quot;:[&quot;\u003cstring\u003e&quot;,&quot;\u003cstring\u003e&quot;]},{&quot;name&quot;:&quot;\u003cstring\u003e&quot;,&quot;objects&quot;:[&quot;\u003cstring\u003e&quot;,&quot;\u003cstring\u003e&quot;]}]},{&quot;operations&quot;:[&quot;\u003cstring\u003e&quot;,&quot;\u003cstring\u003e&quot;],&quot;schemas&quot;:[{&quot;name&quot;:&quot;\u003cstring\u003e&quot;,&quot;objects&quot;:[&quot;\u003cstring\u003e&quot;,&quot;\u003cstring\u003e&quot;]},{&quot;name&quot;:&quot;\u003cstring\u003e&quot;,&quot;objects&quot;:[&quot;\u003cstring\u003e&quot;,&quot;\u003cstring\u003e&quot;]}]}],&quot;recommendations&quot;:[{&quot;message&quot;:&quot;\u003cstring\u003e&quot;,&quot;example&quot;:{&quot;lines&quot;:[{&quot;comment&quot;:&quot;\u003cstring\u003e&quot;,&quot;operation&quot;:&quot;\u003cstring\u003e&quot;},{&quot;comment&quot;:&quot;\u003cstring\u003e&quot;,&quot;operation&quot;:&quot;\u003cstring\u003e&quot;}]},&quot;rationales&quot;:[{&quot;message&quot;:&quot;\u003cstring\u003e&quot;},{&quot;message&quot;:&quot;\u003cstring\u003e&quot;}]},{&quot;message&quot;:&quot;\u003cstring\u003e&quot;,&quot;example&quot;:{&quot;lines&quot;:[{&quot;comment&quot;:&quot;\u003cstring\u003e&quot;,&quot;operation&quot;:&quot;\u003cstring\u003e&quot;},{&quot;comment&quot;:&quot;\u003cstring\u003e&quot;,&quot;operation&quot;:&quot;\u003cstring\u003e&quot;}]},&quot;rationales&quot;:[{&quot;message&quot;:&quot;\u003cstring\u003e&quot;},{&quot;message&quot;:&quot;\u003cstring\u003e&quot;}]}]}]},{&quot;name&quot;:&quot;\u003cstring\u003e&quot;,&quot;description&quot;:&quot;\u003cstring\u003e&quot;,&quot;findings&quot;:[{&quot;message&quot;:&quot;\u003cstring\u003e&quot;,&quot;details&quot;:[{&quot;operations&quot;:[&quot;\u003cstring\u003e&quot;,&quot;\u003cstring\u003e&quot;],&quot;schemas&quot;:[{&quot;name&quot;:&quot;\u003cstring\u003e&quot;,&quot;objects&quot;:[&quot;\u003cstring\u003e&quot;,&quot;\u003cstring\u003e&quot;]},{&quot;name&quot;:&quot;\u003cstring\u003e&quot;,&quot;objects&quot;:[&quot;\u003cstring\u003e&quot;,&quot;\u003cstring\u003e&quot;]}]},{&quot;operations&quot;:[&quot;\u003cstring\u003e&quot;,&quot;\u003cstring\u003e&quot;],&quot;schemas&quot;:[{&quot;name&quot;:&quot;\u003cstring\u003e&quot;,&quot;objects&quot;:[&quot;\u003cstring\u003e&quot;,&quot;\u003cstring\u003e&quot;]},{&quot;name&quot;:&quot;\u003cstring\u003e&quot;,&quot;objects&quot;:[&quot;\u003cstring\u003e&quot;,&quot;\u003cstring\u003e&quot;]}]}],&quot;recommendations&quot;:[{&quot;message&quot;:&quot;\u003cstring\u003e&quot;,&quot;example&quot;:{&quot;lines&quot;:[{&quot;comment&quot;:&quot;\u003cstring\u003e&quot;,&quot;operation&quot;:&quot;\u003cstring\u003e&quot;},{&quot;comment&quot;:&quot;\u003cstring\u003e&quot;,&quot;operation&quot;:&quot;\u003cstring\u003e&quot;}]},&quot;rationales&quot;:[{&quot;message&quot;:&quot;\u003cstring\u003e&quot;},{&quot;message&quot;:&quot;\u003cstring\u003e&quot;}]},{&quot;message&quot;:&quot;\u003cstring\u003e&quot;,&quot;example&quot;:{&quot;lines&quot;:[{&quot;comment&quot;:&quot;\u003cstring\u003e&quot;,&quot;operation&quot;:&quot;\u003cstring\u003e&quot;},{&quot;comment&quot;:&quot;\u003cstring\u003e&quot;,&quot;operation&quot;:&quot;\u003cstring\u003e&quot;}]},&quot;rationales&quot;:[{&quot;message&quot;:&quot;\u003cstring\u003e&quot;},{&quot;message&quot;:&quot;\u003cstring\u003e&quot;}]}]},{&quot;message&quot;:&quot;\u003cstring\u003e&quot;,&quot;details&quot;:[{&quot;operations&quot;:[&quot;\u003cstring\u003e&quot;,&quot;\u003cstring\u003e&quot;],&quot;schemas&quot;:[{&quot;name&quot;:&quot;\u003cstring\u003e&quot;,&quot;objects&quot;:[&quot;\u003cstring\u003e&quot;,&quot;\u003cstring\u003e&quot;]},{&quot;name&quot;:&quot;\u003cstring\u003e&quot;,&quot;objects&quot;:[&quot;\u003cstring\u003e&quot;,&quot;\u003cstring\u003e&quot;]}]},{&quot;operations&quot;:[&quot;\u003cstring\u003e&quot;,&quot;\u003cstring\u003e&quot;],&quot;schemas&quot;:[{&quot;name&quot;:&quot;\u003cstring\u003e&quot;,&quot;objects&quot;:[&quot;\u003cstring\u003e&quot;,&quot;\u003cstring\u003e&quot;]},{&quot;name&quot;:&quot;\u003cstring\u003e&quot;,&quot;objects&quot;:[&quot;\u003cstring\u003e&quot;,&quot;\u003cstring\u003e&quot;]}]}],&quot;recommendations&quot;:[{&quot;message&quot;:&quot;\u003cstring\u003e&quot;,&quot;example&quot;:{&quot;lines&quot;:[{&quot;comment&quot;:&quot;\u003cstring\u003e&quot;,&quot;operation&quot;:&quot;\u003cstring\u003e&quot;},{&quot;comment&quot;:&quot;\u003cstring\u003e&quot;,&quot;operation&quot;:&quot;\u003cstring\u003e&quot;}]},&quot;rationales&quot;:[{&quot;message&quot;:&quot;\u003cstring\u003e&quot;},{&quot;message&quot;:&quot;\u003cstring\u003e&quot;}]},{&quot;message&quot;:&quot;\u003cstring\u003e&quot;,&quot;example&quot;:{&quot;lines&quot;:[{&quot;comment&quot;:&quot;\u003cstring\u003e&quot;,&quot;operation&quot;:&quot;\u003cstring\u003e&quot;},{&quot;comment&quot;:&quot;\u003cstring\u003e&quot;,&quot;operation&quot;:&quot;\u003cstring\u003e&quot;}]},&quot;rationales&quot;:[{&quot;message&quot;:&quot;\u003cstring\u003e&quot;},{&quot;message&quot;:&quot;\u003cstring\u003e&quot;}]}]}]}]},&quot;status&quot;:&quot;INTERRUPTED&quot;,&quot;taskName&quot;:&quot;\u003cstring\u003e&quot;,&quot;timeEnd&quot;:&quot;\u003cdateTime\u003e&quot;,&quot;timeStart&quot;:&quot;\u003cdateTime\u003e&quot;,&quot;errorMessage&quot;:&quot;\u003cstring\u003e&quot;,&quot;findings&quot;:&quot;\u003cinteger\u003e&quot;,&quot;statusMessage&quot;:&quot;\u003cstring\u003e&quot;}