Loads plans from Automatic Workload Repository (AWR) snapshots.

POST {{baseUrl}}/managedDatabases/:managedDatabaseId/sqlPlanBaselines/actions/loadSqlPlanBaselinesFromAwr

Loads plans from Automatic Workload Repository (AWR) snapshots. You must specify the beginning and ending of the snapshot range. Optionally, you can apply a filter to load only plans that meet specified criteria. By default, the optimizer uses the loaded plans the next time that the database executes the SQL statements.

Request Body

{"jobName"=>"<string>", "beginSnapshot"=>"<integer>", "endSnapshot"=>"<integer>", "credentials"=>{"credentialType"=>"PASSWORD", "username"=>"<string>", "role"=>"SYSDBA"}, "databaseCredential"=>{"credentialType"=>"SECRET"}, "isEnabled"=>"<boolean>", "isFixed"=>"<boolean>", "jobDescription"=>"<string>", "sqlTextFilter"=>"<string>"}

HEADERS

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

RESPONSES

status: OK

{&quot;name&quot;:&quot;\u003cstring\u003e&quot;,&quot;type&quot;:&quot;LOAD&quot;,&quot;status&quot;:&quot;SUCCEEDED&quot;,&quot;timeCreated&quot;:&quot;\u003cdateTime\u003e&quot;}