SqlInsightAggregation¶

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

Bases: object

Represents a SQL Insight.

Methods

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

Attributes

`category`	[Required] Gets the category of this SqlInsightAggregation.
`text`	[Required] Gets the text of this SqlInsightAggregation.
`values`	[Required] Gets the values of this SqlInsightAggregation.

__init__(**kwargs)¶

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

Parameters:	text (str) – The value to assign to the text property of this SqlInsightAggregation. values (list[int]) – The value to assign to the values property of this SqlInsightAggregation. category (str) – The value to assign to the category property of this SqlInsightAggregation.

category¶

[Required] Gets the category of this SqlInsightAggregation. Insight category. It would be one of the following DEGRADING, VARIANT, INEFFICIENT, CHANGING_PLANS, IMPROVING, DEGRADING_VARIANT, DEGRADING_INEFFICIENT, DEGRADING_CHANGING_PLANS, DEGRADING_INCREASING_IO, DEGRADING_INCREASING_CPU, DEGRADING_INCREASING_INEFFICIENT_WAIT, DEGRADING_CHANGING_PLANS_AND_INCREASING_IO, DEGRADING_CHANGING_PLANS_AND_INCREASING_CPU, DEGRADING_CHANGING_PLANS_AND_INCREASING_INEFFICIENT_WAIT,VARIANT_INEFFICIENT, VARIANT_CHANGING_PLANS, VARIANT_INCREASING_IO, VARIANT_INCREASING_CPU, VARIANT_INCREASING_INEFFICIENT_WAIT, VARIANT_CHANGING_PLANS_AND_INCREASING_IO, VARIANT_CHANGING_PLANS_AND_INCREASING_CPU, VARIANT_CHANGING_PLANS_AND_INCREASING_INEFFICIENT_WAIT, INEFFICIENT_CHANGING_PLANS, INEFFICIENT_INCREASING_INEFFICIENT_WAIT, INEFFICIENT_CHANGING_PLANS_AND_INCREASING_INEFFICIENT_WAIT

Returns:	The category of this SqlInsightAggregation.
Return type:	str

text¶

[Required] Gets the text of this SqlInsightAggregation. Insight text. For example Degrading SQLs, Variant SQLs,

Inefficient SQLs, Improving SQLs, SQLs with Plan Changes, Degrading SQLs have increasing IO Time above 50%, Degrading SQLs are variant, 2 of the 2 variant SQLs have plan changes, `Inefficient SQLs have increasing CPU Time above 50%

Returns:	The text of this SqlInsightAggregation.
Return type:	str

values¶

[Required] Gets the values of this SqlInsightAggregation. SQL counts for a given insight. For example insight text 2 of 10 SQLs have degrading response time will have values as [2,10]”

Returns:	The values of this SqlInsightAggregation.
Return type:	list[int]