Class SqlInsightThresholds

Inventory details.

Inheritance

object

SqlInsightThresholds

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Namespace: Oci.OpsiService.Models

Assembly: OCI.DotNetSDK.Opsi.dll

Syntax

public class SqlInsightThresholds

Properties

DegradationInPct

Declaration

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

Property Value

Type	Description
int?	Degradation Percent Threshold is used to derive degrading SQLs.

Remarks

Required

ImprovedInPct

Declaration

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

Property Value

Type	Description
int?	Improved Percent Threshold is used to derive improving SQLs.

Remarks

Required

IncreaseInCPUInPct

Declaration

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

Property Value

Type	Description
int?	PctIncreaseInCPU is used for deriving insights for SQLs which are degrading or variant or inefficient. And these SQLs should also have increasing change in CPU Time beyond threshold. Insights are derived using linear regression.

Remarks

Required

IncreaseInIOInPct

Declaration

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

Property Value

Type	Description
int?	PctIncreaseInIO is used for deriving insights for SQLs which are degrading or variant or inefficient. And these SQLs should also have increasing change in IO Time beyond threshold. Insights are derived using linear regression.

Remarks

Required

IncreaseInInefficientWaitInPct

Declaration

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

Property Value

Type	Description
int?	PctIncreaseInIO is used for deriving insights for SQLs which are degrading or variant or inefficient. And these SQLs should also have increasing change in Other Wait Time beyond threshold. Insights are derived using linear regression.

Remarks

Required

InefficiencyInPct

Declaration

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

Property Value

Type	Description
int?	Inefficiency Percent Threshold is used to derive inefficient SQLs.

Remarks

Required

Variability

Declaration

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

Property Value

Type	Description
float?	Variability Percent Threshold is used to derive variant SQLs.

Remarks

Required