Gets the findings and possible actions for a given object in a SQL tuning task.

GET {{baseUrl}}/managedDatabases/:managedDatabaseId/sqlTuningAdvisorTasks/:sqlTuningAdvisorTaskId/recommendations?sqlObjectId=<long>&executionId=<long>&sortBy=RECOMMENDATION_TYPE&sortOrder=DESC&page=<string>&limit=10

Gets the findings and possible actions for a given object in a SQL tuning task. The task ID and object ID are used to retrieve the findings and recommendations.

Request Params

KeyDatatypeRequiredDescription
sqlObjectIdstring(Required) The SQL object ID for the SQL tuning task. This is not the OCID.
executionIdstring(Required) The execution ID for an execution of a SQL tuning task. This is not the OCID.
sortBystringThe possible sortBy values of an object's recommendations.
sortOrderstringThe option to sort information in ascending (‘ASC’) or descending (‘DESC’) order. Descending order is the default order.
pagestringThe page token representing the page from where the next set of paginated results
are retrieved. This is usually retrieved from a previous list call.
limitnumberThe maximum number of records returned in the paginated response.

HEADERS

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

RESPONSES

status: OK

{&quot;items&quot;:[{&quot;recommendationKey&quot;:&quot;\u003cinteger\u003e&quot;,&quot;recommendationType&quot;:&quot;ERROR&quot;,&quot;sqlTuningAdvisorTaskId&quot;:&quot;\u003clong\u003e&quot;,&quot;sqlTuningAdvisorTaskObjectId&quot;:&quot;\u003clong\u003e&quot;,&quot;benefit&quot;:&quot;\u003cfloat\u003e&quot;,&quot;finding&quot;:&quot;\u003cstring\u003e&quot;,&quot;implementActionSql&quot;:&quot;\u003cstring\u003e&quot;,&quot;isParallelExecution&quot;:&quot;\u003cboolean\u003e&quot;,&quot;rationale&quot;:&quot;\u003cstring\u003e&quot;,&quot;recommendation&quot;:&quot;\u003cstring\u003e&quot;},{&quot;recommendationKey&quot;:&quot;\u003cinteger\u003e&quot;,&quot;recommendationType&quot;:&quot;SQL_PROFILE&quot;,&quot;sqlTuningAdvisorTaskId&quot;:&quot;\u003clong\u003e&quot;,&quot;sqlTuningAdvisorTaskObjectId&quot;:&quot;\u003clong\u003e&quot;,&quot;benefit&quot;:&quot;\u003cfloat\u003e&quot;,&quot;finding&quot;:&quot;\u003cstring\u003e&quot;,&quot;implementActionSql&quot;:&quot;\u003cstring\u003e&quot;,&quot;isParallelExecution&quot;:&quot;\u003cboolean\u003e&quot;,&quot;rationale&quot;:&quot;\u003cstring\u003e&quot;,&quot;recommendation&quot;:&quot;\u003cstring\u003e&quot;}]}