Gets an array of details for the findings that match the given filters.
GET {{baseUrl}}/managedDatabases/:managedDatabaseId/sqlTuningAdvisorTasks/:sqlTuningAdvisorTaskId/findings?beginExecId=<long>&endExecId=<long>&searchPeriod=ALL&findingFilter=none&statsHashFilter=<string>&indexHashFilter=<string>&sortBy=DBTIME_BENEFIT&sortOrder=DESC&page=<string>&limit=10
Gets an array of the details of the findings that match specific filters.
Request Params
| Key | Datatype | Required | Description |
|---|---|---|---|
beginExecId | string | The optional greater than or equal to filter on the execution ID related to a specific SQL Tuning Advisor task. | |
endExecId | string | The optional less than or equal to query parameter to filter on the execution ID related to a specific SQL Tuning Advisor task. | |
searchPeriod | string | The search period during which the API will search for begin and end exec id, if not supplied. | |
| Unused if beginExecId and endExecId optional query params are both supplied. | |||
findingFilter | string | The filter used to display specific findings in the report. | |
statsHashFilter | string | The hash value of the object for the statistic finding search. | |
indexHashFilter | string | The hash value of the index table name. | |
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":[{"sqlTuningAdvisorTaskId":"\u003clong\u003e","sqlTuningAdvisorTaskObjectId":"\u003clong\u003e","sqlTuningAdvisorTaskObjectExecutionId":"\u003clong\u003e","parsingSchema":"\u003cstring\u003e","sqlText":"\u003cstring\u003e","sqlKey":"\u003cstring\u003e","dbTimeBenefit":"\u003cfloat\u003e","isAlternativePlanFindingPresent":"\u003cboolean\u003e","isErrorFindingPresent":"\u003cboolean\u003e","isIndexFindingPresent":"\u003cboolean\u003e","isMiscellaneousFindingPresent":"\u003cboolean\u003e","isRestructureSqlFindingPresent":"\u003cboolean\u003e","isSqlProfileFindingImplemented":"\u003cboolean\u003e","isSqlProfileFindingPresent":"\u003cboolean\u003e","isStatsFindingPresent":"\u003cboolean\u003e","isTimeoutFindingPresent":"\u003cboolean\u003e","perExecutionPercentage":"\u003cinteger\u003e"},{"sqlTuningAdvisorTaskId":"\u003clong\u003e","sqlTuningAdvisorTaskObjectId":"\u003clong\u003e","sqlTuningAdvisorTaskObjectExecutionId":"\u003clong\u003e","parsingSchema":"\u003cstring\u003e","sqlText":"\u003cstring\u003e","sqlKey":"\u003cstring\u003e","dbTimeBenefit":"\u003cfloat\u003e","isAlternativePlanFindingPresent":"\u003cboolean\u003e","isErrorFindingPresent":"\u003cboolean\u003e","isIndexFindingPresent":"\u003cboolean\u003e","isMiscellaneousFindingPresent":"\u003cboolean\u003e","isRestructureSqlFindingPresent":"\u003cboolean\u003e","isSqlProfileFindingImplemented":"\u003cboolean\u003e","isSqlProfileFindingPresent":"\u003cboolean\u003e","isStatsFindingPresent":"\u003cboolean\u003e","isTimeoutFindingPresent":"\u003cboolean\u003e","perExecutionPercentage":"\u003cinteger\u003e"}]}