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]
-