Class ChangeSqlPlanBaselinesAttributesDetails

The details required to change SQL plan baseline attributes. It takes either credentials or databaseCredential. It's recommended to provide databaseCredential

Inheritance

object

ChangeSqlPlanBaselinesAttributesDetails

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 ChangeSqlPlanBaselinesAttributesDetails

Properties

Credentials

Declaration

[JsonProperty(PropertyName = "credentials")]
public ManagedDatabaseCredential Credentials { get; set; }

Property Value

Type	Description
ManagedDatabaseCredential

DatabaseCredential

Declaration

[JsonProperty(PropertyName = "databaseCredential")]
public DatabaseCredentialDetails DatabaseCredential { get; set; }

Property Value

Type	Description
DatabaseCredentialDetails

IsAutoPurged

Declaration

[JsonProperty(PropertyName = "isAutoPurged")]
public bool? IsAutoPurged { get; set; }

Property Value

Type	Description
bool?	Indicates whether the plan is purged if it is not used for a time period.

IsEnabled

Declaration

[JsonProperty(PropertyName = "isEnabled")]
public bool? IsEnabled { get; set; }

Property Value

Type	Description
bool?	Indicates whether the plan is available for use by the optimizer.

IsFixed

Declaration

[JsonProperty(PropertyName = "isFixed")]
public bool? IsFixed { get; set; }

Property Value

Type	Description
bool?	Indicates whether the plan baseline is fixed. A fixed plan takes precedence over a non-fixed plan.

PlanName

Declaration

[JsonProperty(PropertyName = "planName")]
public string PlanName { get; set; }

Property Value

Type	Description
string	Then plan name. It identifies a specific plan. If `null' then all plans associated with a SQL statement identified by` sqlHandle' are considered for attribute changes.

SqlHandle

Declaration

[JsonProperty(PropertyName = "sqlHandle")]
public string SqlHandle { get; set; }

Property Value

Type	Description
string	The SQL statement handle. It identifies plans associated with a SQL statement for attribute changes. If `null` then `planName` must be specified.