SqlInsightThresholds¶

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

Bases: object

Inventory details.

Methods

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

Attributes

`degradation_in_pct`	[Required] Gets the degradation_in_pct of this SqlInsightThresholds.
`improved_in_pct`	[Required] Gets the improved_in_pct of this SqlInsightThresholds.
`increase_in_cpu_in_pct`	[Required] Gets the increase_in_cpu_in_pct of this SqlInsightThresholds.
`increase_in_inefficient_wait_in_pct`	[Required] Gets the increase_in_inefficient_wait_in_pct of this SqlInsightThresholds.
`increase_in_io_in_pct`	[Required] Gets the increase_in_io_in_pct of this SqlInsightThresholds.
`inefficiency_in_pct`	[Required] Gets the inefficiency_in_pct of this SqlInsightThresholds.
`variability`	[Required] Gets the variability of this SqlInsightThresholds.

__init__(**kwargs)¶

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

Parameters:

degradation_in_pct (int) – The value to assign to the degradation_in_pct property of this SqlInsightThresholds.
variability (float) – The value to assign to the variability property of this SqlInsightThresholds.
inefficiency_in_pct (int) – The value to assign to the inefficiency_in_pct property of this SqlInsightThresholds.
increase_in_io_in_pct (int) – The value to assign to the increase_in_io_in_pct property of this SqlInsightThresholds.
increase_in_cpu_in_pct (int) – The value to assign to the increase_in_cpu_in_pct property of this SqlInsightThresholds.
increase_in_inefficient_wait_in_pct (int) – The value to assign to the increase_in_inefficient_wait_in_pct property of this SqlInsightThresholds.
improved_in_pct (int) – The value to assign to the improved_in_pct property of this SqlInsightThresholds.

degradation_in_pct¶

[Required] Gets the degradation_in_pct of this SqlInsightThresholds. Degradation Percent Threshold is used to derive degrading SQLs.

Returns:	The degradation_in_pct of this SqlInsightThresholds.
Return type:	int

improved_in_pct¶

[Required] Gets the improved_in_pct of this SqlInsightThresholds. Improved Percent Threshold is used to derive improving SQLs.

Returns:	The improved_in_pct of this SqlInsightThresholds.
Return type:	int

increase_in_cpu_in_pct¶

[Required] Gets the increase_in_cpu_in_pct of this SqlInsightThresholds. PctIncreaseInCPU is used for deriving insights for SQLs which are degrading or variant or inefficient. And these SQLs should also have increasing change in CPU Time beyond threshold. Insights are derived using linear regression.

Returns:	The increase_in_cpu_in_pct of this SqlInsightThresholds.
Return type:	int

increase_in_inefficient_wait_in_pct¶

[Required] Gets the increase_in_inefficient_wait_in_pct of this SqlInsightThresholds. PctIncreaseInIO is used for deriving insights for SQLs which are degrading or variant or inefficient. And these SQLs should also have increasing change in Other Wait Time beyond threshold. Insights are derived using linear regression.

Returns:	The increase_in_inefficient_wait_in_pct of this SqlInsightThresholds.
Return type:	int

increase_in_io_in_pct¶

[Required] Gets the increase_in_io_in_pct of this SqlInsightThresholds. PctIncreaseInIO is used for deriving insights for SQLs which are degrading or variant or inefficient. And these SQLs should also have increasing change in IO Time beyond threshold. Insights are derived using linear regression.

Returns:	The increase_in_io_in_pct of this SqlInsightThresholds.
Return type:	int

inefficiency_in_pct¶

[Required] Gets the inefficiency_in_pct of this SqlInsightThresholds. Inefficiency Percent Threshold is used to derive inefficient SQLs.

Returns:	The inefficiency_in_pct of this SqlInsightThresholds.
Return type:	int

variability¶

[Required] Gets the variability of this SqlInsightThresholds. Variability Percent Threshold is used to derive variant SQLs.

Returns:	The variability of this SqlInsightThresholds.
Return type:	float