Class SqlPlanBaselineSummary

The summary of a SQL plan baseline.

Inheritance
object
SqlPlanBaselineSummary
Inherited Members
Namespace: Oci.DatabasemanagementService.Models
Assembly: OCI.DotNetSDK.Databasemanagement.dll
Syntax
public class SqlPlanBaselineSummary

Properties

Accepted

Declaration
[JsonProperty(PropertyName = "accepted")]
[JsonConverter(typeof(ResponseEnumConverter))]
public SqlPlanBaselineSummary.AcceptedEnum? Accepted { get; set; }
Property Value
Type Description
SqlPlanBaselineSummary.AcceptedEnum?

Indicates whether the plan baseline is accepted (YES) or not (NO).

Adaptive

Declaration
[JsonProperty(PropertyName = "adaptive")]
[JsonConverter(typeof(ResponseEnumConverter))]
public SqlPlanBaselineSummary.AdaptiveEnum? Adaptive { get; set; }
Property Value
Type Description
SqlPlanBaselineSummary.AdaptiveEnum?

Indicates whether a plan that is automatically captured by SQL plan management is marked adaptive or not.
When a new adaptive plan is found for a SQL statement that has an existing SQL plan baseline, that new plan will be added to the SQL plan baseline as an unaccepted plan, and the ADAPTIVE property will be marked YES. When this new plan is verified (either manually or via the auto evolve task), the plan will be test executed and the final plan determined at execution will become an accepted plan if its performance is better than the existing plan baseline. At this point, the value of the ADAPTIVE property is set to NO since the plan is no longer adaptive, but resolved.

AutoPurge

Declaration
[JsonProperty(PropertyName = "autoPurge")]
[JsonConverter(typeof(ResponseEnumConverter))]
public SqlPlanBaselineSummary.AutoPurgeEnum? AutoPurge { get; set; }
Property Value
Type Description
SqlPlanBaselineSummary.AutoPurgeEnum?

Indicates whether the plan baseline is auto-purged (YES) or not (NO).

Enabled

Declaration
[JsonProperty(PropertyName = "enabled")]
[JsonConverter(typeof(ResponseEnumConverter))]
public SqlPlanBaselineSummary.EnabledEnum? Enabled { get; set; }
Property Value
Type Description
SqlPlanBaselineSummary.EnabledEnum?

Indicates whether the plan baseline is enabled (YES) or disabled (NO).

Fixed

Declaration
[JsonProperty(PropertyName = "fixed")]
[JsonConverter(typeof(ResponseEnumConverter))]
public SqlPlanBaselineSummary.FixedEnum? Fixed { get; set; }
Property Value
Type Description
SqlPlanBaselineSummary.FixedEnum?

Indicates whether the plan baseline is fixed (YES) or not (NO).

Origin

Declaration
[JsonProperty(PropertyName = "origin")]
[JsonConverter(typeof(ResponseEnumConverter))]
public SqlPlanBaselineOrigin? Origin { get; set; }
Property Value
Type Description
SqlPlanBaselineOrigin?

The origin of the SQL plan baseline.

PlanName

Declaration
[Required(ErrorMessage = "PlanName is required.")]
[JsonProperty(PropertyName = "planName")]
public string PlanName { get; set; }
Property Value
Type Description
string

The unique plan identifier.
Remarks

Required

Reproduced

Declaration
[JsonProperty(PropertyName = "reproduced")]
[JsonConverter(typeof(ResponseEnumConverter))]
public SqlPlanBaselineSummary.ReproducedEnum? Reproduced { get; set; }
Property Value
Type Description
SqlPlanBaselineSummary.ReproducedEnum?

Indicates whether the optimizer was able to reproduce the plan (YES) or not (NO). The value is set to YES when a plan is initially added to the plan baseline.

SqlHandle

Declaration
[Required(ErrorMessage = "SqlHandle is required.")]
[JsonProperty(PropertyName = "sqlHandle")]
public string SqlHandle { get; set; }
Property Value
Type Description
string

The unique SQL identifier.
Remarks

Required

SqlText

Declaration
[Required(ErrorMessage = "SqlText is required.")]
[JsonProperty(PropertyName = "sqlText")]
public string SqlText { get; set; }
Property Value
Type Description
string

The SQL text (truncated to the first 50 characters).
Remarks

Required

TimeCreated

Declaration
[Required(ErrorMessage = "TimeCreated is required.")]
[JsonProperty(PropertyName = "timeCreated")]
public DateTime? TimeCreated { get; set; }
Property Value
Type Description
DateTime?

The date and time when the plan baseline was created.
Remarks

Required

TimeLastExecuted

Declaration
[JsonProperty(PropertyName = "timeLastExecuted")]
public DateTime? TimeLastExecuted { get; set; }
Property Value
Type Description
DateTime?

The date and time when the plan baseline was last executed.
Note: For performance reasons, database does not update this value immediately after each execution of the plan baseline. Therefore, the plan baseline may have been executed more recently than this value indicates.

TimeLastModified

Declaration
[JsonProperty(PropertyName = "timeLastModified")]
public DateTime? TimeLastModified { get; set; }
Property Value
Type Description
DateTime?

The date and time when the plan baseline was last modified.