Enables the use of SQL plan baselines stored in SQL Management Base.
POST {{baseUrl}}/managedDatabases/:managedDatabaseId/sqlPlanBaselines/actions/enableSqlPlanBaselinesUsage
Enables the use of SQL plan baselines stored in SQL Management Base.
When enabled, the optimizer uses SQL plan baselines to select plans to avoid potential performance regressions.
Request Body
{"credentials"=>{"credentialType"=>"SECRET", "username"=>"<string>", "role"=>"SYSDBA"}, "databaseCredential"=>{"credentialType"=>"NAMED_CREDENTIAL"}}
HEADERS
Key | Datatype | Required | Description |
---|---|---|---|
opc-request-id | string | The client request ID for tracing. | |
Content-Type | string | ||
Accept | string |
RESPONSES
status: OK
""