Class SqlStatisticsTimeSeriesByPlanAggregationCollection

SQL performance statistics by plan over the selected time window.

Inheritance
object
SqlStatisticsTimeSeriesByPlanAggregationCollection
Inherited Members
Namespace: Oci.OpsiService.Models
Assembly: OCI.DotNetSDK.Opsi.dll
Syntax
public class SqlStatisticsTimeSeriesByPlanAggregationCollection

Properties

DatabaseId

Declaration
[Required(ErrorMessage = "DatabaseId is required.")]
[JsonProperty(PropertyName = "databaseId")]
public string DatabaseId { get; set; }
Property Value
Type Description
string

The OCID of the database.
Remarks

Required

EndTimestamps

Declaration
[Required(ErrorMessage = "EndTimestamps is required.")]
[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.
Remarks

Required

Id

Declaration
[Required(ErrorMessage = "Id is required.")]
[JsonProperty(PropertyName = "id")]
public string Id { get; set; }
Property Value
Type Description
string

The OCID of the database insight resource.
Remarks

Required

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<SqlStatisticsTimeSeriesByPlanAggregation> Items { get; set; }
Property Value
Type Description
List<SqlStatisticsTimeSeriesByPlanAggregation>

array of SQL performance statistics by plans
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