SqlStatisticsTimeSeriesByPlanAggregationCollection

class oci.opsi.models.SqlStatisticsTimeSeriesByPlanAggregationCollection(**kwargs)

Bases: object

SQL performance statistics by plan over the selected time window.

Methods:

__init__(**kwargs)

Initializes a new SqlStatisticsTimeSeriesByPlanAggregationCollection object with values from keyword arguments.

Attributes:

database_id

[Required] Gets the database_id of this SqlStatisticsTimeSeriesByPlanAggregationCollection.

end_timestamps

[Required] Gets the end_timestamps of this SqlStatisticsTimeSeriesByPlanAggregationCollection.

id

[Required] Gets the id of this SqlStatisticsTimeSeriesByPlanAggregationCollection.

item_duration_in_ms

[Required] Gets the item_duration_in_ms of this SqlStatisticsTimeSeriesByPlanAggregationCollection.

items

[Required] Gets the items of this SqlStatisticsTimeSeriesByPlanAggregationCollection.

sql_identifier

[Required] Gets the sql_identifier of this SqlStatisticsTimeSeriesByPlanAggregationCollection.

time_interval_end

[Required] Gets the time_interval_end of this SqlStatisticsTimeSeriesByPlanAggregationCollection.

time_interval_start

[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