My Oracle Support Banner

Automatic Deletion of SQL Plan Baselines Does Not Delete Plans That Exceed 'PLAN_RETENTION_WEEKS' (Doc ID 2794301.1)

Last updated on APRIL 17, 2023

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.



  1. Parameter 'PLAN_RETENTION_WEEKS'. This parameter can have any value between 5 to 523 weeks; with a default value of 53 (1 year plus 1 week).
  2. Attribute 'autopurge', set on individual Baselines.



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.