Class SqlPlanBaseline

The details of a SQL plan baseline.

Inheritance

object

SqlPlanBaseline

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 SqlPlanBaseline

Properties

Accepted

Declaration

[JsonProperty(PropertyName = "accepted")]
[JsonConverter(typeof(ResponseEnumConverter))]
public SqlPlanBaseline.AcceptedEnum? Accepted { get; set; }

Property Value

Type	Description
SqlPlanBaseline.AcceptedEnum?	Indicates whether the plan baseline is accepted (YES) or not (NO).

Action

Declaration

[JsonProperty(PropertyName = "action")]
public string Action { get; set; }

Property Value

Type	Description
string	The application action.

Adaptive

Declaration

[JsonProperty(PropertyName = "adaptive")]
[JsonConverter(typeof(ResponseEnumConverter))]
public SqlPlanBaseline.AdaptiveEnum? Adaptive { get; set; }

Property Value

Type

Description

SqlPlanBaseline.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 SqlPlanBaseline.AutoPurgeEnum? AutoPurge { get; set; }

Property Value

Type	Description
SqlPlanBaseline.AutoPurgeEnum?	Indicates whether the plan baseline is auto-purged (YES) or not (NO).

Enabled

Declaration

[JsonProperty(PropertyName = "enabled")]
[JsonConverter(typeof(ResponseEnumConverter))]
public SqlPlanBaseline.EnabledEnum? Enabled { get; set; }

Property Value

Type	Description
SqlPlanBaseline.EnabledEnum?	Indicates whether the plan baseline is enabled (YES) or disabled (NO).

ExecutionPlan

Declaration

[Required(ErrorMessage = "ExecutionPlan is required.")]
[JsonProperty(PropertyName = "executionPlan")]
public string ExecutionPlan { get; set; }

Property Value

Type	Description
string	The execution plan for the SQL statement.

Remarks

Required

Fixed

Declaration

[JsonProperty(PropertyName = "fixed")]
[JsonConverter(typeof(ResponseEnumConverter))]
public SqlPlanBaseline.FixedEnum? Fixed { get; set; }

Property Value

Type	Description
SqlPlanBaseline.FixedEnum?	Indicates whether the plan baseline is fixed (YES) or not (NO).

Module

Declaration

[JsonProperty(PropertyName = "module")]
public string Module { get; set; }

Property Value

Type	Description
string	The application module name.

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 SqlPlanBaseline.ReproducedEnum? Reproduced { get; set; }

Property Value

Type	Description
SqlPlanBaseline.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.

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.