Class SqlPlanInsightAggregation

SQL execution plan Performance statistics.

Inheritance

object

SqlPlanInsightAggregation

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 SqlPlanInsightAggregation

Properties

CpuTimeInSec

Declaration

[Required(ErrorMessage = "CpuTimeInSec is required.")]
[JsonProperty(PropertyName = "cpuTimeInSec")]
public double CpuTimeInSec { get; set; }

Property Value

Type	Description
double	CPU Time in seconds

Remarks

Required

ExecutionsCount

Declaration

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

Property Value

Type	Description
long?	Total number of executions

Remarks

Required

InefficientWaitTimeInSec

Declaration

[Required(ErrorMessage = "InefficientWaitTimeInSec is required.")]
[JsonProperty(PropertyName = "inefficientWaitTimeInSec")]
public double InefficientWaitTimeInSec { get; set; }

Property Value

Type	Description
double	Inefficient Wait Time in seconds

Remarks

Required

IoTimeInSec

Declaration

[Required(ErrorMessage = "IoTimeInSec is required.")]
[JsonProperty(PropertyName = "ioTimeInSec")]
public double IoTimeInSec { get; set; }

Property Value

Type	Description
double	IO Time in seconds

Remarks

Required

PlanHash

Declaration

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

Property Value

Type	Description
long?	Plan hash value for the SQL Execution Plan

Remarks

Required