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
Key | Datatype | Required | Description |
---|---|---|---|
opc-request-id | string | The client request ID for tracing. | |
Content-Type | string | ||
Accept | string |
RESPONSES
status: OK
""