Class SqlBucket

Sql bucket type object.

Inheritance

object

SqlBucket

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 SqlBucket

Properties

BucketId

Declaration

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

Property Value

Type	Description
string

CpuTimeInSec

Declaration

[JsonProperty(PropertyName = "cpuTimeInSec")]
public float? CpuTimeInSec { get; set; }

Property Value

Type	Description
float?	Total CPU time Example: 1046

DatabaseType

Declaration

[JsonProperty(PropertyName = "databaseType")]
public string DatabaseType { get; set; }

Property Value

Type	Description
string	Ops Insights internal representation of the database type.

ExecutionsCount

Declaration

[JsonProperty(PropertyName = "executionsCount")]
public int? ExecutionsCount { get; set; }

Property Value

Type	Description
int?	Total number of executions Example: 60

IoTimeInSec

Declaration

[JsonProperty(PropertyName = "ioTimeInSec")]
public float? IoTimeInSec { get; set; }

Property Value

Type	Description
float?	Total IO time Example: 5810

OtherWaitTimeInSec

Declaration

[JsonProperty(PropertyName = "otherWaitTimeInSec")]
public float? OtherWaitTimeInSec { get; set; }

Property Value

Type	Description
float?	Total other wait time Example: 24061

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

SqlIdentifier

Declaration

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

Property Value

Type	Description
string	Unique SQL_ID for a SQL Statement.

Remarks

Required

TimeCollected

Declaration

[Required(ErrorMessage = "TimeCollected is required.")]
[JsonProperty(PropertyName = "timeCollected")]
public DateTime? TimeCollected { get; set; }

Property Value

Type	Description
DateTime?	Collection timestamp Example: "2020-03-31T00:00:00.000Z"

Remarks

Required

TotalTimeInSec

Declaration

[JsonProperty(PropertyName = "totalTimeInSec")]
public float? TotalTimeInSec { get; set; }

Property Value

Type	Description
float?	Total time Example: 30917

Version

Declaration

[JsonProperty(PropertyName = "version")]
public float? Version { get; set; }

Property Value

Type	Description
float?	Version Example: 1