SqlTuningTaskPlanStats¶

class oci.database_management.models.SqlTuningTaskPlanStats(**kwargs)¶

Bases: object

The statistics of a SQL execution plan.

Attributes

`PLAN_STATUS_COMPLETE`	A constant which can be used with the plan_status property of a SqlTuningTaskPlanStats.
`PLAN_STATUS_PARTIAL`	A constant which can be used with the plan_status property of a SqlTuningTaskPlanStats.
`plan_stats`	[Required] Gets the plan_stats of this SqlTuningTaskPlanStats.
`plan_status`	[Required] Gets the plan_status of this SqlTuningTaskPlanStats.
`plan_type`	[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’.

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)

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

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