Class SqlPlanBaselineConfiguration

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

Inheritance

object

SqlPlanBaselineConfiguration

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Namespace: Oci.DatabasemanagementService.Models

Assembly: OCI.DotNetSDK.Databasemanagement.dll

Syntax

public class SqlPlanBaselineConfiguration

Properties

AutoCaptureFilters

Declaration

[JsonProperty(PropertyName = "autoCaptureFilters")]
public List<AutomaticCaptureFilter> AutoCaptureFilters { get; set; }

Property Value

Type	Description
List<AutomaticCaptureFilter>	The capture filters used in automatic initial plan capture.

AutoSpmEvolveTaskParameters

Declaration

[JsonProperty(PropertyName = "autoSpmEvolveTaskParameters")]
public SpmEvolveTaskParameters AutoSpmEvolveTaskParameters { get; set; }

Property Value

Type	Description
SpmEvolveTaskParameters

IsAutoSpmEvolveTaskEnabled

Declaration

[Required(ErrorMessage = "IsAutoSpmEvolveTaskEnabled is required.")]
[JsonProperty(PropertyName = "isAutoSpmEvolveTaskEnabled")]
public bool? IsAutoSpmEvolveTaskEnabled { get; set; }

Property Value

Type	Description
bool?	Indicates whether the Automatic SPM Evolve Advisor task is enabled (true) or not (false).

Remarks

Required

IsAutomaticInitialPlanCaptureEnabled

Declaration

[Required(ErrorMessage = "IsAutomaticInitialPlanCaptureEnabled is required.")]
[JsonProperty(PropertyName = "isAutomaticInitialPlanCaptureEnabled")]
public bool? IsAutomaticInitialPlanCaptureEnabled { get; set; }

Property Value

Type	Description
bool?	Indicates whether the automatic capture of SQL plan baselines is enabled (true) or not (false).

Remarks

Required

IsHighFrequencyAutoSpmEvolveTaskEnabled

Declaration

[Required(ErrorMessage = "IsHighFrequencyAutoSpmEvolveTaskEnabled is required.")]
[JsonProperty(PropertyName = "isHighFrequencyAutoSpmEvolveTaskEnabled")]
public bool? IsHighFrequencyAutoSpmEvolveTaskEnabled { get; set; }

Property Value

Type	Description
bool?	Indicates whether the high frequency Automatic SPM Evolve Advisor task is enabled (true) or not (false).

Remarks

Required

IsSqlPlanBaselinesUsageEnabled

Declaration

[Required(ErrorMessage = "IsSqlPlanBaselinesUsageEnabled is required.")]
[JsonProperty(PropertyName = "isSqlPlanBaselinesUsageEnabled")]
public bool? IsSqlPlanBaselinesUsageEnabled { get; set; }

Property Value

Type	Description
bool?	Indicates whether the database uses SQL plan baselines (true) or not (false).

Remarks

Required

PlanRetentionWeeks

Declaration

[Required(ErrorMessage = "PlanRetentionWeeks is required.")]
[JsonProperty(PropertyName = "planRetentionWeeks")]
public int? PlanRetentionWeeks { get; set; }

Property Value

Type	Description
int?	The number of weeks to retain unused plans before they are purged.

Remarks

Required

SpaceBudgetMB

Declaration

[JsonProperty(PropertyName = "spaceBudgetMB")]
public float? SpaceBudgetMB { get; set; }

Property Value

Type	Description
float?	The maximum SYSAUX space that can be used for SQL Management Base in MB.

SpaceBudgetPercent

Declaration

[Required(ErrorMessage = "SpaceBudgetPercent is required.")]
[JsonProperty(PropertyName = "spaceBudgetPercent")]
public float? SpaceBudgetPercent { get; set; }

Property Value

Type	Description
float?	The maximum percent of SYSAUX space that can be used for SQL Management Base.

Remarks

Required

SpaceUsedMB

Declaration

[JsonProperty(PropertyName = "spaceUsedMB")]
public float? SpaceUsedMB { get; set; }

Property Value

Type	Description
float?	The space used by SQL Management Base in MB.