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.
`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.

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

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

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