Changes the retention period of unused plans.

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

Changes the retention period of unused plans. The period can range between 5 and 523 weeks.

The database purges plans that have not been used for longer than the plan retention period.

Request Body

{"retentionWeeks"=>"<integer>", "credentials"=>{"credentialType"=>"PASSWORD", "username"=>"<string>", "role"=>"SYSDBA"}, "databaseCredential"=>{"credentialType"=>"PASSWORD"}}

HEADERS

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

RESPONSES

status: OK

&quot;&quot;