Show / Hide Table of Contents

Class SqlStatisticsTimeSeriesAggregationCollection

SQL performance statistics over the selected time window.

Inheritance
object
SqlStatisticsTimeSeriesAggregationCollection
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 SqlStatisticsTimeSeriesAggregationCollection

Properties

EndTimestamps

Declaration
[JsonProperty(PropertyName = "endTimestamps")]
public List<DateTime> EndTimestamps { get; set; }
Property Value
Type Description
List<DateTime>

Array comprising of all the sampling period end timestamps in RFC 3339 format.

ItemDurationInMs

Declaration
[Required(ErrorMessage = "ItemDurationInMs is required.")]
[JsonProperty(PropertyName = "itemDurationInMs")]
public long? ItemDurationInMs { get; set; }
Property Value
Type Description
long?

Time duration in milliseconds between data points (one hour or one day).

Remarks

Required

Items

Declaration
[Required(ErrorMessage = "Items is required.")]
[JsonProperty(PropertyName = "items")]
public List<SqlStatisticsTimeSeriesAggregation> Items { get; set; }
Property Value
Type Description
List<SqlStatisticsTimeSeriesAggregation>

Array of SQL performance statistics across databases.

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

TimeIntervalEnd

Declaration
[Required(ErrorMessage = "TimeIntervalEnd is required.")]
[JsonProperty(PropertyName = "timeIntervalEnd")]
public DateTime? TimeIntervalEnd { get; set; }
Property Value
Type Description
DateTime?

The end timestamp that was passed into the request.

Remarks

Required

TimeIntervalStart

Declaration
[Required(ErrorMessage = "TimeIntervalStart is required.")]
[JsonProperty(PropertyName = "timeIntervalStart")]
public DateTime? TimeIntervalStart { get; set; }
Property Value
Type Description
DateTime?

The start timestamp that was passed into the request.

Remarks

Required

In this article
Back to top