SqlStatisticsTimeSeriesAggregationCollection¶

class oci.opsi.models.SqlStatisticsTimeSeriesAggregationCollection(**kwargs)¶

Bases: object

SQL performance statistics over the selected time window.

Methods

__init__(**kwargs) Initializes a new SqlStatisticsTimeSeriesAggregationCollection object with values from keyword arguments.

Attributes

`end_timestamps`	Gets the end_timestamps of this SqlStatisticsTimeSeriesAggregationCollection.
`item_duration_in_ms`	[Required] Gets the item_duration_in_ms of this SqlStatisticsTimeSeriesAggregationCollection.
`items`	[Required] Gets the items of this SqlStatisticsTimeSeriesAggregationCollection.
`sql_identifier`	[Required] Gets the sql_identifier of this SqlStatisticsTimeSeriesAggregationCollection.
`time_interval_end`	[Required] Gets the time_interval_end of this SqlStatisticsTimeSeriesAggregationCollection.
`time_interval_start`	[Required] Gets the time_interval_start of this SqlStatisticsTimeSeriesAggregationCollection.

__init__(**kwargs)¶

Initializes a new SqlStatisticsTimeSeriesAggregationCollection object with values from keyword arguments. The following keyword arguments are supported (corresponding to the getters/setters of this class):

Parameters:

sql_identifier (str) – The value to assign to the sql_identifier property of this SqlStatisticsTimeSeriesAggregationCollection.
time_interval_start (datetime) – The value to assign to the time_interval_start property of this SqlStatisticsTimeSeriesAggregationCollection.
time_interval_end (datetime) – The value to assign to the time_interval_end property of this SqlStatisticsTimeSeriesAggregationCollection.
item_duration_in_ms (int) – The value to assign to the item_duration_in_ms property of this SqlStatisticsTimeSeriesAggregationCollection.
end_timestamps (list[datetime]) – The value to assign to the end_timestamps property of this SqlStatisticsTimeSeriesAggregationCollection.
items (list[oci.opsi.models.SqlStatisticsTimeSeriesAggregation]) – The value to assign to the items property of this SqlStatisticsTimeSeriesAggregationCollection.

end_timestamps¶

Gets the end_timestamps of this SqlStatisticsTimeSeriesAggregationCollection. Array comprising of all the sampling period end timestamps in RFC 3339 format.

Returns:	The end_timestamps of this SqlStatisticsTimeSeriesAggregationCollection.
Return type:	list[datetime]

item_duration_in_ms¶

[Required] Gets the item_duration_in_ms of this SqlStatisticsTimeSeriesAggregationCollection. Time duration in milliseconds between data points (one hour or one day).

Returns:	The item_duration_in_ms of this SqlStatisticsTimeSeriesAggregationCollection.
Return type:	int

items¶

[Required] Gets the items of this SqlStatisticsTimeSeriesAggregationCollection. Array of SQL performance statistics across databases.

Returns:	The items of this SqlStatisticsTimeSeriesAggregationCollection.
Return type:	list[oci.opsi.models.SqlStatisticsTimeSeriesAggregation]

sql_identifier¶

[Required] Gets the sql_identifier of this SqlStatisticsTimeSeriesAggregationCollection. Unique SQL_ID for a SQL Statement.

Returns:	The sql_identifier of this SqlStatisticsTimeSeriesAggregationCollection.
Return type:	str

time_interval_end¶

[Required] Gets the time_interval_end of this SqlStatisticsTimeSeriesAggregationCollection. The end timestamp that was passed into the request.

Returns:	The time_interval_end of this SqlStatisticsTimeSeriesAggregationCollection.
Return type:	datetime

time_interval_start¶

[Required] Gets the time_interval_start of this SqlStatisticsTimeSeriesAggregationCollection. The start timestamp that was passed into the request.

Returns:	The time_interval_start of this SqlStatisticsTimeSeriesAggregationCollection.
Return type:	datetime