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.

property 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

property 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

property 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

property 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

property 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

property 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

property 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