Enables the Automatic SPM Evolve Advisor task.
POST {{baseUrl}}/managedDatabases/:managedDatabaseId/sqlPlanBaselines/actions/enableAutomaticSpmEvolveAdvisorTask
Enables the Automatic SPM Evolve Advisor task. By default, the automatic task
SYS_AUTO_SPM_EVOLVE_TASK
runs every day in the scheduled maintenance window.
The SPM Evolve Advisor performs the following tasks:
- Checks AWR for top SQL
- Looks for alternative plans in all available sources
- Adds unaccepted plans to the plan history
- Tests the execution of as many plans as possible during the maintenance window
- Adds the alternative plan to the baseline if it performs better than the current plan
One client controls both Automatic SQL Tuning Advisor and Automatic SPM Evolve Advisor. Thus, the same task enables or disables both.
Request Body
{"credentials"=>{"credentialType"=>"PASSWORD", "username"=>"<string>", "role"=>"NORMAL"}, "databaseCredential"=>{"credentialType"=>"SECRET"}}
HEADERS
Key | Datatype | Required | Description |
---|---|---|---|
opc-request-id | string | The client request ID for tracing. | |
Content-Type | string | ||
Accept | string |
RESPONSES
status: OK
""