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

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