SqlStatisticsTimeSeriesByPlanAggregationCollection¶
- class oci.opsi.models.SqlStatisticsTimeSeriesByPlanAggregationCollection(**kwargs)¶
Bases:
objectSQL performance statistics by plan over the selected time window.
Methods:
__init__(**kwargs)Initializes a new SqlStatisticsTimeSeriesByPlanAggregationCollection object with values from keyword arguments.
Attributes:
[Required] Gets the database_id of this SqlStatisticsTimeSeriesByPlanAggregationCollection.
[Required] Gets the end_timestamps of this SqlStatisticsTimeSeriesByPlanAggregationCollection.
[Required] Gets the id of this SqlStatisticsTimeSeriesByPlanAggregationCollection.
[Required] Gets the item_duration_in_ms of this SqlStatisticsTimeSeriesByPlanAggregationCollection.
[Required] Gets the items of this SqlStatisticsTimeSeriesByPlanAggregationCollection.
[Required] Gets the sql_identifier of this SqlStatisticsTimeSeriesByPlanAggregationCollection.
[Required] Gets the time_interval_end of this SqlStatisticsTimeSeriesByPlanAggregationCollection.
[Required] Gets the time_interval_start of this SqlStatisticsTimeSeriesByPlanAggregationCollection.
- __init__(**kwargs)¶
Initializes a new SqlStatisticsTimeSeriesByPlanAggregationCollection 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 SqlStatisticsTimeSeriesByPlanAggregationCollection.
id (str) – The value to assign to the id property of this SqlStatisticsTimeSeriesByPlanAggregationCollection.
database_id (str) – The value to assign to the database_id property of this SqlStatisticsTimeSeriesByPlanAggregationCollection.
time_interval_start (datetime) – The value to assign to the time_interval_start property of this SqlStatisticsTimeSeriesByPlanAggregationCollection.
time_interval_end (datetime) – The value to assign to the time_interval_end property of this SqlStatisticsTimeSeriesByPlanAggregationCollection.
item_duration_in_ms (int) – The value to assign to the item_duration_in_ms property of this SqlStatisticsTimeSeriesByPlanAggregationCollection.
end_timestamps (list[datetime]) – The value to assign to the end_timestamps property of this SqlStatisticsTimeSeriesByPlanAggregationCollection.
items (list[oci.opsi.models.SqlStatisticsTimeSeriesByPlanAggregation]) – The value to assign to the items property of this SqlStatisticsTimeSeriesByPlanAggregationCollection.
- property database_id¶
[Required] Gets the database_id of this SqlStatisticsTimeSeriesByPlanAggregationCollection. The OCID of the database.
- Returns
The database_id of this SqlStatisticsTimeSeriesByPlanAggregationCollection.
- Return type
str
- property end_timestamps¶
[Required] Gets the end_timestamps of this SqlStatisticsTimeSeriesByPlanAggregationCollection. Array comprising of all the sampling period end timestamps in RFC 3339 format.
- Returns
The end_timestamps of this SqlStatisticsTimeSeriesByPlanAggregationCollection.
- Return type
list[datetime]
- property id¶
[Required] Gets the id of this SqlStatisticsTimeSeriesByPlanAggregationCollection. The OCID of the database insight resource.
- Returns
The id of this SqlStatisticsTimeSeriesByPlanAggregationCollection.
- Return type
str
- property item_duration_in_ms¶
[Required] Gets the item_duration_in_ms of this SqlStatisticsTimeSeriesByPlanAggregationCollection. Time duration in milliseconds between data points (one hour or one day).
- Returns
The item_duration_in_ms of this SqlStatisticsTimeSeriesByPlanAggregationCollection.
- Return type
int
- property items¶
[Required] Gets the items of this SqlStatisticsTimeSeriesByPlanAggregationCollection. array of SQL performance statistics by plans
- Returns
The items of this SqlStatisticsTimeSeriesByPlanAggregationCollection.
- Return type
list[oci.opsi.models.SqlStatisticsTimeSeriesByPlanAggregation]
- property sql_identifier¶
[Required] Gets the sql_identifier of this SqlStatisticsTimeSeriesByPlanAggregationCollection. Unique SQL_ID for a SQL Statement.
- Returns
The sql_identifier of this SqlStatisticsTimeSeriesByPlanAggregationCollection.
- Return type
str
- property time_interval_end¶
[Required] Gets the time_interval_end of this SqlStatisticsTimeSeriesByPlanAggregationCollection. The end timestamp that was passed into the request.
- Returns
The time_interval_end of this SqlStatisticsTimeSeriesByPlanAggregationCollection.
- Return type
datetime
- property time_interval_start¶
[Required] Gets the time_interval_start of this SqlStatisticsTimeSeriesByPlanAggregationCollection. The start timestamp that was passed into the request.
- Returns
The time_interval_start of this SqlStatisticsTimeSeriesByPlanAggregationCollection.
- Return type
datetime