Loads plans for statements directly from the shared SQL area, also called the cursor cache.

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

Loads plans for statements directly from the shared SQL area, also called the cursor cache. By applying a filter on the module name, the schema, or the SQL ID you identify the SQL statement or set of SQL statements to load.

Request Body

{"jobName"=>"<string>", "credentials"=>{"credentialType"=>"PASSWORD", "username"=>"<string>", "role"=>"NORMAL"}, "databaseCredential"=>{"credentialType"=>"SECRET"}, "filterName"=>"ACTION", "filterValue"=>"<string>", "isEnabled"=>"<boolean>", "isFixed"=>"<boolean>", "jobDescription"=>"<string>", "planHash"=>"<number>", "sqlHandle"=>"<string>", "sqlId"=>"<string>", "sqlText"=>"<string>"}

HEADERS

RESPONSES

status: OK

{"name":"\u003cstring\u003e","type":"LOAD","status":"SUCCEEDED","timeCreated":"\u003cdateTime\u003e"}