Gets the SQL Tuning Advisor summary report.
GET {{baseUrl}}/managedDatabases/:managedDatabaseId/sqlTuningAdvisorTasks/:sqlTuningAdvisorTaskId/summaryReport?searchPeriod=ALL&timeGreaterThanOrEqualTo=<dateTime>&timeLessThanOrEqualTo=<dateTime>&beginExecIdGreaterThanOrEqualTo=<long>&endExecIdLessThanOrEqualTo=<long>
Gets the summary report for the specified SQL Tuning Advisor task.
Request Params
Key | Datatype | Required | Description |
---|---|---|---|
searchPeriod | string | How far back the API will search for begin and end exec id. Unused if neither exec ids nor time filter query params are supplied. This is applicable only for Auto SQL Tuning tasks. | |
timeGreaterThanOrEqualTo | string | The optional greater than or equal to query parameter to filter the timestamp. This is applicable only for Auto SQL Tuning tasks. | |
timeLessThanOrEqualTo | string | The optional less than or equal to query parameter to filter the timestamp. This is applicable only for Auto SQL Tuning tasks. | |
beginExecIdGreaterThanOrEqualTo | string | The optional greater than or equal to filter on the execution ID related to a specific SQL Tuning Advisor task. This is applicable only for Auto SQL Tuning tasks. | |
endExecIdLessThanOrEqualTo | string | The optional less than or equal to query parameter to filter on the execution ID related to a specific SQL Tuning Advisor task. This is applicable only for Auto SQL Tuning tasks. |
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
{"taskInfo":{"id":"\u003clong\u003e","name":"\u003cstring\u003e","owner":"\u003cstring\u003e","timeStarted":"\u003cdateTime\u003e","timeEnded":"\u003cdateTime\u003e","description":"\u003cstring\u003e","runningTime":"\u003cinteger\u003e","status":"INITIAL"},"statistics":{"statementCounts":{"distinctSql":"\u003cinteger\u003e","totalSql":"\u003cinteger\u003e","findingCount":"\u003cinteger\u003e","errorCount":"\u003cinteger\u003e"},"findingCounts":{"recommendedSqlProfile":"\u003cinteger\u003e","implementedSqlProfile":"\u003cinteger\u003e","index":"\u003cinteger\u003e","restructure":"\u003cinteger\u003e","statistics":"\u003cinteger\u003e","alternatePlan":"\u003cinteger\u003e"},"findingBenefits":{"dbTimeBeforeRecommended":"\u003cinteger\u003e","dbTimeAfterRecommended":"\u003cinteger\u003e","dbTimeBeforeImplemented":"\u003cinteger\u003e","dbTimeAfterImplemented":"\u003cinteger\u003e"}},"indexFindings":[{"indexHashValue":"\u003clong\u003e","indexName":"\u003cstring\u003e","tableName":"\u003cstring\u003e","schema":"\u003cstring\u003e","referenceCount":"\u003cinteger\u003e","indexColumns":["\u003cstring\u003e","\u003cstring\u003e"]},{"indexHashValue":"\u003clong\u003e","indexName":"\u003cstring\u003e","tableName":"\u003cstring\u003e","schema":"\u003cstring\u003e","referenceCount":"\u003cinteger\u003e","indexColumns":["\u003cstring\u003e","\u003cstring\u003e"]}],"objectStatFindings":[{"objectHashValue":"\u003clong\u003e","objectName":"\u003cstring\u003e","objectType":"\u003cstring\u003e","schema":"\u003cstring\u003e","problemType":"STALE","referenceCount":"\u003cinteger\u003e"},{"objectHashValue":"\u003clong\u003e","objectName":"\u003cstring\u003e","objectType":"\u003cstring\u003e","schema":"\u003cstring\u003e","problemType":"STALE","referenceCount":"\u003cinteger\u003e"}]}