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

KeyDatatypeRequiredDescription
searchPeriodstringHow 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.
timeGreaterThanOrEqualTostringThe optional greater than or equal to query parameter to filter the timestamp. This is applicable only for Auto SQL Tuning tasks.
timeLessThanOrEqualTostringThe optional less than or equal to query parameter to filter the timestamp. This is applicable only for Auto SQL Tuning tasks.
beginExecIdGreaterThanOrEqualTostringThe 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.
endExecIdLessThanOrEqualTostringThe 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

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

RESPONSES

status: OK

{&quot;taskInfo&quot;:{&quot;id&quot;:&quot;\u003clong\u003e&quot;,&quot;name&quot;:&quot;\u003cstring\u003e&quot;,&quot;owner&quot;:&quot;\u003cstring\u003e&quot;,&quot;timeStarted&quot;:&quot;\u003cdateTime\u003e&quot;,&quot;timeEnded&quot;:&quot;\u003cdateTime\u003e&quot;,&quot;description&quot;:&quot;\u003cstring\u003e&quot;,&quot;runningTime&quot;:&quot;\u003cinteger\u003e&quot;,&quot;status&quot;:&quot;INITIAL&quot;},&quot;statistics&quot;:{&quot;statementCounts&quot;:{&quot;distinctSql&quot;:&quot;\u003cinteger\u003e&quot;,&quot;totalSql&quot;:&quot;\u003cinteger\u003e&quot;,&quot;findingCount&quot;:&quot;\u003cinteger\u003e&quot;,&quot;errorCount&quot;:&quot;\u003cinteger\u003e&quot;},&quot;findingCounts&quot;:{&quot;recommendedSqlProfile&quot;:&quot;\u003cinteger\u003e&quot;,&quot;implementedSqlProfile&quot;:&quot;\u003cinteger\u003e&quot;,&quot;index&quot;:&quot;\u003cinteger\u003e&quot;,&quot;restructure&quot;:&quot;\u003cinteger\u003e&quot;,&quot;statistics&quot;:&quot;\u003cinteger\u003e&quot;,&quot;alternatePlan&quot;:&quot;\u003cinteger\u003e&quot;},&quot;findingBenefits&quot;:{&quot;dbTimeBeforeRecommended&quot;:&quot;\u003cinteger\u003e&quot;,&quot;dbTimeAfterRecommended&quot;:&quot;\u003cinteger\u003e&quot;,&quot;dbTimeBeforeImplemented&quot;:&quot;\u003cinteger\u003e&quot;,&quot;dbTimeAfterImplemented&quot;:&quot;\u003cinteger\u003e&quot;}},&quot;indexFindings&quot;:[{&quot;indexHashValue&quot;:&quot;\u003clong\u003e&quot;,&quot;indexName&quot;:&quot;\u003cstring\u003e&quot;,&quot;tableName&quot;:&quot;\u003cstring\u003e&quot;,&quot;schema&quot;:&quot;\u003cstring\u003e&quot;,&quot;referenceCount&quot;:&quot;\u003cinteger\u003e&quot;,&quot;indexColumns&quot;:[&quot;\u003cstring\u003e&quot;,&quot;\u003cstring\u003e&quot;]},{&quot;indexHashValue&quot;:&quot;\u003clong\u003e&quot;,&quot;indexName&quot;:&quot;\u003cstring\u003e&quot;,&quot;tableName&quot;:&quot;\u003cstring\u003e&quot;,&quot;schema&quot;:&quot;\u003cstring\u003e&quot;,&quot;referenceCount&quot;:&quot;\u003cinteger\u003e&quot;,&quot;indexColumns&quot;:[&quot;\u003cstring\u003e&quot;,&quot;\u003cstring\u003e&quot;]}],&quot;objectStatFindings&quot;:[{&quot;objectHashValue&quot;:&quot;\u003clong\u003e&quot;,&quot;objectName&quot;:&quot;\u003cstring\u003e&quot;,&quot;objectType&quot;:&quot;\u003cstring\u003e&quot;,&quot;schema&quot;:&quot;\u003cstring\u003e&quot;,&quot;problemType&quot;:&quot;STALE&quot;,&quot;referenceCount&quot;:&quot;\u003cinteger\u003e&quot;},{&quot;objectHashValue&quot;:&quot;\u003clong\u003e&quot;,&quot;objectName&quot;:&quot;\u003cstring\u003e&quot;,&quot;objectType&quot;:&quot;\u003cstring\u003e&quot;,&quot;schema&quot;:&quot;\u003cstring\u003e&quot;,&quot;problemType&quot;:&quot;STALE&quot;,&quot;referenceCount&quot;:&quot;\u003cinteger\u003e&quot;}]}