Class SqlInsightAggregation

Represents a SQL Insight.

Inheritance

object

SqlInsightAggregation

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 SqlInsightAggregation

Properties

Category

Declaration

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

Property Value

Type

Description

string

Insight category. It would be one of the following DEGRADING, VARIANT, INEFFICIENT, CHANGING_PLANS, IMPROVING, DEGRADING_VARIANT, DEGRADING_INEFFICIENT, DEGRADING_CHANGING_PLANS, DEGRADING_INCREASING_IO, DEGRADING_INCREASING_CPU, DEGRADING_INCREASING_INEFFICIENT_WAIT, DEGRADING_CHANGING_PLANS_AND_INCREASING_IO, DEGRADING_CHANGING_PLANS_AND_INCREASING_CPU, DEGRADING_CHANGING_PLANS_AND_INCREASING_INEFFICIENT_WAIT,VARIANT_INEFFICIENT, VARIANT_CHANGING_PLANS, VARIANT_INCREASING_IO, VARIANT_INCREASING_CPU, VARIANT_INCREASING_INEFFICIENT_WAIT, VARIANT_CHANGING_PLANS_AND_INCREASING_IO, VARIANT_CHANGING_PLANS_AND_INCREASING_CPU, VARIANT_CHANGING_PLANS_AND_INCREASING_INEFFICIENT_WAIT, INEFFICIENT_CHANGING_PLANS, INEFFICIENT_INCREASING_INEFFICIENT_WAIT, INEFFICIENT_CHANGING_PLANS_AND_INCREASING_INEFFICIENT_WAIT

Remarks

Required

Text

Declaration

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

Property Value

Type	Description
string	Insight text. For example Degrading SQLs, Variant SQLs, Inefficient SQLs, Improving SQLs, SQLs with Plan Changes, Degrading SQLs have increasing IO Time above 50%, Degrading SQLs are variant, 2 of the 2 variant SQLs have plan changes, `Inefficient SQLs have increasing CPU Time above 50%

Remarks

Required

Values

Declaration

[Required(ErrorMessage = "Values is required.")]
[JsonProperty(PropertyName = "values")]
public List<int> Values { get; set; }

Property Value

Type	Description
List<int>	SQL counts for a given insight. For example insight text 2 of 10 SQLs have degrading response time will have values as [2,10]"

Remarks

Required