Configures the Automatic SPM Evolve Advisor task.
POST {{baseUrl}}/managedDatabases/:managedDatabaseId/sqlPlanBaselines/actions/configureAutomaticSpmEvolveAdvisorTask
Configures the Automatic SPM Evolve Advisor task SYS_AUTO_SPM_EVOLVE_TASK
by specifying task parameters. As the task is owned by SYS
, only SYS
can
set task parameters.
Request Body
{"taskParameters"=>{"allowedTimeLimit"=>"<integer>", "alternatePlanBaselines"=>["AUTO", "AUTO"], "alternatePlanLimit"=>"<integer>", "alternatePlanSources"=>["CURSOR_CACHE", "SQL_TUNING_SET"], "arePlansAutoAccepted"=>"<boolean>"}, "credentials"=>{"credentialType"=>"PASSWORD", "username"=>"<string>", "role"=>"NORMAL"}, "databaseCredential"=>{"credentialType"=>"PASSWORD"}}
HEADERS
Key | Datatype | Required | Description |
---|---|---|---|
opc-request-id | string | The client request ID for tracing. | |
Content-Type | string | ||
Accept | string |
RESPONSES
status: OK
""