Class SqlPlanInsightAggregation
SQL execution plan Performance statistics.
Inherited Members
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