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

KeyDatatypeRequiredDescription
opc-request-idstringThe client request ID for tracing.
Content-Typestring
Acceptstring

RESPONSES

status: OK

&quot;&quot;