Start a SQL tuning task in the database
POST {{baseUrl}}/managedDatabases/:managedDatabaseId/actions/startSqlTuningTask
Starts a SQL tuning task for a given set of SQL statements from the active session history top SQL statements.
Request Body
{"taskName"=>"<string>", "totalTimeLimitInMinutes"=>"<integer>", "scope"=>"LIMITED", "credentialDetails"=>{"sqlTuningTaskCredentialType"=>"PASSWORD", "username"=>"<string>", "role"=>"NORMAL"}, "databaseCredential"=>{"credentialType"=>"PASSWORD"}, "sqlDetails"=>[{"sqlId"=>"<string>"}, {"sqlId"=>"<string>"}], "sqlTuningSet"=>{"name"=>"<string>", "owner"=>"<string>"}, "statementTimeLimitInMinutes"=>"<integer>", "taskDescription"=>"<string>", "timeEnded"=>"<dateTime>", "timeStarted"=>"<dateTime>"}
HEADERS
Key | Datatype | Required | Description |
---|---|---|---|
opc-request-id | string | The client request ID for tracing. | |
opc-retry-token | string | A token that uniquely identifies a request so it can be retried in case of a timeout or | |
server error without risk of executing that same action again. Retry tokens expire after 24 | |||
hours, but can be invalidated before then due to conflicting operations. For example, if a resource | |||
has been deleted and purged from the system, then a retry of the original creation request | |||
might be rejected. | |||
Content-Type | string | ||
Accept | string |
RESPONSES
status: OK
{"sqlTuningTaskId":"\u003clong\u003e"}