Show / Hide Table of Contents

Class SqlPlanInsightAggregationCollection

SQL plan insights response.

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

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

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

Insights

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

List of SQL plan insights.

Remarks

Required

Items

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

List of SQL plan statistics.

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