SqlTuningTaskPlanStats

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

Bases: object

The statistics of an 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 plan for the original or the new plan with profile/index etc.

Returns:The plan_type of this SqlTuningTaskPlanStats.
Return type:str