SqlPlanInsights

class oci.opsi.models.SqlPlanInsights(**kwargs)

Bases: object

Represents collection of SQL Plan Insights.

Methods:

__init__(**kwargs)

Initializes a new SqlPlanInsights object with values from keyword arguments.

Attributes:

category

[Required] Gets the category of this SqlPlanInsights.

text

[Required] Gets the text of this SqlPlanInsights. SQL Plan Insight text. For example Number of Plans Used, Most Executed Plan, Best Performing Plan, Worst Performing Plan, Plan With Most IO, Plan with Most CPU.

value

[Required] Gets the value of this SqlPlanInsights.

__init__(**kwargs)

Initializes a new SqlPlanInsights 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 SqlPlanInsights.

  • value (int) – The value to assign to the value property of this SqlPlanInsights.

  • category (str) – The value to assign to the category property of this SqlPlanInsights.

property category

[Required] Gets the category of this SqlPlanInsights. SQL Insight category. For example PLANS_USED, MOST_EXECUTED, BEST_PERFORMER, WORST_PERFORMER, MOST_CPU or MOST_IO.

Returns

The category of this SqlPlanInsights.

Return type

str

property text

[Required] Gets the text of this SqlPlanInsights. SQL Plan Insight text. For example Number of Plans Used, Most Executed Plan,

Best Performing Plan, Worst Performing Plan, Plan With Most IO, Plan with Most CPU

Returns

The text of this SqlPlanInsights.

Return type

str

property value

[Required] Gets the value of this SqlPlanInsights. SQL execution plan hash value for a given insight. For example Most Executed Plan insight will have value as “3975467901”

Returns

The value of this SqlPlanInsights.

Return type

int