Lists the SQL Tuning Advisor tasks.

GET {{baseUrl}}/managedDatabases/:managedDatabaseId/sqlTuningAdvisorTasks?name=<string>&status=INTERRUPTED&timeGreaterThanOrEqualTo=<dateTime>&timeLessThanOrEqualTo=<dateTime>&page=<string>&limit=10&sortBy=START_TIME&sortOrder=DESC

Lists the SQL Tuning Advisor tasks for the specified Managed Database.

Request Params

KeyDatatypeRequiredDescription
namestringThe optional query parameter to filter the SQL Tuning Advisor task list by name.
statusstringThe optional query parameter to filter the SQL Tuning Advisor task list by status.
timeGreaterThanOrEqualTostringThe optional greater than or equal to query parameter to filter the timestamp.
timeLessThanOrEqualTostringThe optional less than or equal to query parameter to filter the timestamp.
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.
sortBystringThe option to sort the SQL Tuning Advisor task summary data.
sortOrderstringThe option to sort information in ascending (‘ASC’) or descending (‘DESC’) order. Descending order is the default order.

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;sqlTuningAdvisorTaskId&quot;:&quot;\u003clong\u003e&quot;,&quot;daysToExpire&quot;:&quot;\u003cinteger\u003e&quot;,&quot;description&quot;:&quot;\u003cstring\u003e&quot;,&quot;instanceId&quot;:&quot;\u003cinteger\u003e&quot;,&quot;name&quot;:&quot;\u003cstring\u003e&quot;,&quot;owner&quot;:&quot;\u003cstring\u003e&quot;,&quot;recommendationCount&quot;:&quot;\u003cinteger\u003e&quot;,&quot;taskStatus&quot;:&quot;INTERRUPTED&quot;,&quot;timeCreated&quot;:&quot;\u003cdateTime\u003e&quot;,&quot;timeExecutionEnded&quot;:&quot;\u003cdateTime\u003e&quot;,&quot;timeExecutionStarted&quot;:&quot;\u003cdateTime\u003e&quot;,&quot;totalSqlStatements&quot;:&quot;\u003cinteger\u003e&quot;},{&quot;sqlTuningAdvisorTaskId&quot;:&quot;\u003clong\u003e&quot;,&quot;daysToExpire&quot;:&quot;\u003cinteger\u003e&quot;,&quot;description&quot;:&quot;\u003cstring\u003e&quot;,&quot;instanceId&quot;:&quot;\u003cinteger\u003e&quot;,&quot;name&quot;:&quot;\u003cstring\u003e&quot;,&quot;owner&quot;:&quot;\u003cstring\u003e&quot;,&quot;recommendationCount&quot;:&quot;\u003cinteger\u003e&quot;,&quot;taskStatus&quot;:&quot;EXECUTING&quot;,&quot;timeCreated&quot;:&quot;\u003cdateTime\u003e&quot;,&quot;timeExecutionEnded&quot;:&quot;\u003cdateTime\u003e&quot;,&quot;timeExecutionStarted&quot;:&quot;\u003cdateTime\u003e&quot;,&quot;totalSqlStatements&quot;:&quot;\u003cinteger\u003e&quot;}]}