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

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

RESPONSES

status: OK

&quot;&quot;