SqlTuningTaskPlanStats¶
- class oci.database_management.models.SqlTuningTaskPlanStats(**kwargs)¶
Bases:
objectThe statistics of a SQL execution plan.
Attributes:
A constant which can be used with the plan_status property of a SqlTuningTaskPlanStats.
A constant which can be used with the plan_status property of a SqlTuningTaskPlanStats.
[Required] Gets the plan_stats of this SqlTuningTaskPlanStats.
[Required] Gets the plan_status of this SqlTuningTaskPlanStats.
[Required] Gets the plan_type of this SqlTuningTaskPlanStats.
Methods:
__init__(**kwargs)Initializes a new SqlTuningTaskPlanStats object with values from keyword arguments.
- PLAN_STATUS_COMPLETE = 'COMPLETE'¶
A constant which can be used with the plan_status property of a SqlTuningTaskPlanStats. This constant has a value of “COMPLETE”
- PLAN_STATUS_PARTIAL = 'PARTIAL'¶
A constant which can be used with the plan_status property of a SqlTuningTaskPlanStats. This constant has a value of “PARTIAL”
- __init__(**kwargs)¶
Initializes a new SqlTuningTaskPlanStats object with values from keyword arguments. The following keyword arguments are supported (corresponding to the getters/setters of this class):
- Parameters
plan_type (str) – The value to assign to the plan_type property of this SqlTuningTaskPlanStats.
plan_stats (dict(str, float)) – The value to assign to the plan_stats property of this SqlTuningTaskPlanStats.
plan_status (str) – The value to assign to the plan_status property of this SqlTuningTaskPlanStats. Allowed values for this property are: “COMPLETE”, “PARTIAL”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
- property plan_stats¶
[Required] Gets the plan_stats of this SqlTuningTaskPlanStats. A map contains the statistics for the SQL execution using the plan. The key of the map is the metric’s name. The value of the map is the metric’s value.
- Returns
The plan_stats of this SqlTuningTaskPlanStats.
- Return type
dict(str, float)
- property plan_status¶
[Required] Gets the plan_status of this SqlTuningTaskPlanStats. The status of the execution using the plan.
Allowed values for this property are: “COMPLETE”, “PARTIAL”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
- Returns
The plan_status of this SqlTuningTaskPlanStats.
- Return type
str
- property plan_type¶
[Required] Gets the plan_type of this SqlTuningTaskPlanStats. The type of the original or modified plan with profile, index, and so on.
- Returns
The plan_type of this SqlTuningTaskPlanStats.
- Return type
str