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
Key | Datatype | Required | Description |
---|---|---|---|
opc-request-id | string | The client request ID for tracing. | |
Content-Type | string | ||
Accept | string |
RESPONSES
status: OK
{"name":"\u003cstring\u003e","type":"LOAD","status":"SUCCEEDED","timeCreated":"\u003cdateTime\u003e"}