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
Key | Datatype | Required | Description |
---|---|---|---|
name | string | The optional query parameter to filter the SQL Tuning Advisor task list by name. | |
status | string | The optional query parameter to filter the SQL Tuning Advisor task list by status. | |
timeGreaterThanOrEqualTo | string | The optional greater than or equal to query parameter to filter the timestamp. | |
timeLessThanOrEqualTo | string | The optional less than or equal to query parameter to filter the timestamp. | |
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. | |
sortBy | string | The option to sort the SQL Tuning Advisor task summary data. | |
sortOrder | string | The option to sort information in ascending (‘ASC’) or descending (‘DESC’) order. Descending order is the default order. |
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","daysToExpire":"\u003cinteger\u003e","description":"\u003cstring\u003e","instanceId":"\u003cinteger\u003e","name":"\u003cstring\u003e","owner":"\u003cstring\u003e","recommendationCount":"\u003cinteger\u003e","taskStatus":"INTERRUPTED","timeCreated":"\u003cdateTime\u003e","timeExecutionEnded":"\u003cdateTime\u003e","timeExecutionStarted":"\u003cdateTime\u003e","totalSqlStatements":"\u003cinteger\u003e"},{"sqlTuningAdvisorTaskId":"\u003clong\u003e","daysToExpire":"\u003cinteger\u003e","description":"\u003cstring\u003e","instanceId":"\u003cinteger\u003e","name":"\u003cstring\u003e","owner":"\u003cstring\u003e","recommendationCount":"\u003cinteger\u003e","taskStatus":"EXECUTING","timeCreated":"\u003cdateTime\u003e","timeExecutionEnded":"\u003cdateTime\u003e","timeExecutionStarted":"\u003cdateTime\u003e","totalSqlStatements":"\u003cinteger\u003e"}]}