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
Key | Datatype | Required | Description |
---|---|---|---|
sqlObjectId | string | (Required) The SQL object ID for the SQL tuning task. This is not the OCID. | |
executionId | string | (Required) The execution ID for an execution of a SQL tuning task. This is not the OCID. | |
sortBy | string | The possible sortBy values of an object's recommendations. | |
sortOrder | string | The option to sort information in ascending (‘ASC’) or descending (‘DESC’) order. Descending order is the default order. | |
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. |
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":[{"recommendationKey":"\u003cinteger\u003e","recommendationType":"ERROR","sqlTuningAdvisorTaskId":"\u003clong\u003e","sqlTuningAdvisorTaskObjectId":"\u003clong\u003e","benefit":"\u003cfloat\u003e","finding":"\u003cstring\u003e","implementActionSql":"\u003cstring\u003e","isParallelExecution":"\u003cboolean\u003e","rationale":"\u003cstring\u003e","recommendation":"\u003cstring\u003e"},{"recommendationKey":"\u003cinteger\u003e","recommendationType":"SQL_PROFILE","sqlTuningAdvisorTaskId":"\u003clong\u003e","sqlTuningAdvisorTaskObjectId":"\u003clong\u003e","benefit":"\u003cfloat\u003e","finding":"\u003cstring\u003e","implementActionSql":"\u003cstring\u003e","isParallelExecution":"\u003cboolean\u003e","rationale":"\u003cstring\u003e","recommendation":"\u003cstring\u003e"}]}