Class SqlPlanInsights

Represents collection of SQL Plan Insights.

Inheritance

object

SqlPlanInsights

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 SqlPlanInsights

Properties

Category

Declaration

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

Property Value

Type	Description
string	SQL Insight category. For example PLANS_USED, MOST_EXECUTED, BEST_PERFORMER, WORST_PERFORMER, MOST_CPU or MOST_IO.

Remarks

Required

Text

Declaration

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

Property Value

Type	Description
string	SQL Plan Insight text. For example Number of Plans Used, Most Executed Plan, Best Performing Plan, Worst Performing Plan, Plan With Most IO, Plan with Most CPU

Remarks

Required

Value

Declaration

[Required(ErrorMessage = "Value is required.")]
[JsonProperty(PropertyName = "value")]
public long? Value { get; set; }

Property Value

Type	Description
long?	SQL execution plan hash value for a given insight. For example Most Executed Plan insight will have value as "3975467901"

Remarks

Required