SqlPlanInsights¶
- class oci.opsi.models.SqlPlanInsights(**kwargs)¶
Bases:
objectRepresents collection of SQL Plan Insights.
Methods:
__init__(**kwargs)Initializes a new SqlPlanInsights object with values from keyword arguments.
Attributes:
[Required] Gets the category of this SqlPlanInsights.
[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.
[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