The capture filters used in automatic initial plan capture.
Indicates whether the Automatic SPM Evolve Advisor task is enabled ({@code true}) or not ({@code false}).
Indicates whether the automatic capture of SQL plan baselines is enabled ({@code true}) or not ({@code false}).
Indicates whether the high frequency Automatic SPM Evolve Advisor task is enabled ({@code true}) or not ({@code false}).
Indicates whether the database uses SQL plan baselines ({@code true}) or not ({@code false}).
The number of weeks to retain unused plans before they are purged. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
The maximum {@code SYSAUX} space that can be used for SQL Management Base in MB. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
The maximum percent of {@code SYSAUX} space that can be used for SQL Management Base. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
The space used by SQL Management Base in MB. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
The configuration details of SQL plan baselines. The details include:
- whether automatic initial plan capture is enabled or disabled - whether use of SQL plan baselines is enabled or disabled - whether Automatic SPM Evolve Advisor task is enabled or disabled - whether high-frequency Automatic SPM Evolve Advisor task is enabled or disabled - filters for the automatic initial plan capture - parameters for the Automatic SPM Evolve Advisor task - plan retention and allocated space for the plan baselines