SqlPlanInsightAggregationCollection¶

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

Bases: object

SQL plan insights response.

Methods

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

Attributes

`database_id`	[Required] Gets the database_id of this SqlPlanInsightAggregationCollection.
`id`	[Required] Gets the id of this SqlPlanInsightAggregationCollection.
`insights`	[Required] Gets the insights of this SqlPlanInsightAggregationCollection.
`items`	[Required] Gets the items of this SqlPlanInsightAggregationCollection.
`sql_identifier`	[Required] Gets the sql_identifier of this SqlPlanInsightAggregationCollection.
`time_interval_end`	[Required] Gets the time_interval_end of this SqlPlanInsightAggregationCollection.
`time_interval_start`	[Required] Gets the time_interval_start of this SqlPlanInsightAggregationCollection.

__init__(**kwargs)¶

Initializes a new SqlPlanInsightAggregationCollection 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 SqlPlanInsightAggregationCollection.
id (str) – The value to assign to the id property of this SqlPlanInsightAggregationCollection.
database_id (str) – The value to assign to the database_id property of this SqlPlanInsightAggregationCollection.
time_interval_start (datetime) – The value to assign to the time_interval_start property of this SqlPlanInsightAggregationCollection.
time_interval_end (datetime) – The value to assign to the time_interval_end property of this SqlPlanInsightAggregationCollection.
insights (list[oci.opsi.models.SqlPlanInsights]) – The value to assign to the insights property of this SqlPlanInsightAggregationCollection.
items (list[oci.opsi.models.SqlPlanInsightAggregation]) – The value to assign to the items property of this SqlPlanInsightAggregationCollection.

database_id¶

[Required] Gets the database_id of this SqlPlanInsightAggregationCollection. The OCID of the database.

Returns:	The database_id of this SqlPlanInsightAggregationCollection.
Return type:	str

id¶

[Required] Gets the id of this SqlPlanInsightAggregationCollection. The OCID of the database insight resource.

Returns:	The id of this SqlPlanInsightAggregationCollection.
Return type:	str

insights¶

[Required] Gets the insights of this SqlPlanInsightAggregationCollection. List of SQL plan insights.

Returns:	The insights of this SqlPlanInsightAggregationCollection.
Return type:	list[oci.opsi.models.SqlPlanInsights]

items¶

[Required] Gets the items of this SqlPlanInsightAggregationCollection. List of SQL plan statistics.

Returns:	The items of this SqlPlanInsightAggregationCollection.
Return type:	list[oci.opsi.models.SqlPlanInsightAggregation]

sql_identifier¶

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

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

time_interval_end¶

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

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

time_interval_start¶

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

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