SqlTuningAdvisorTaskRecommendationSummary

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

Bases: object

A recommendation for a given object in a SQL Tuning Task.

Attributes

RECOMMENDATION_TYPE_ALTERNATIVE_PLANS A constant which can be used with the recommendation_type property of a SqlTuningAdvisorTaskRecommendationSummary.
RECOMMENDATION_TYPE_ERROR A constant which can be used with the recommendation_type property of a SqlTuningAdvisorTaskRecommendationSummary.
RECOMMENDATION_TYPE_INDEX A constant which can be used with the recommendation_type property of a SqlTuningAdvisorTaskRecommendationSummary.
RECOMMENDATION_TYPE_MISCELLANEOUS A constant which can be used with the recommendation_type property of a SqlTuningAdvisorTaskRecommendationSummary.
RECOMMENDATION_TYPE_RESTRUCTURE_SQL A constant which can be used with the recommendation_type property of a SqlTuningAdvisorTaskRecommendationSummary.
RECOMMENDATION_TYPE_SQL_PROFILE A constant which can be used with the recommendation_type property of a SqlTuningAdvisorTaskRecommendationSummary.
RECOMMENDATION_TYPE_STATISTICS A constant which can be used with the recommendation_type property of a SqlTuningAdvisorTaskRecommendationSummary.
benefit Gets the benefit of this SqlTuningAdvisorTaskRecommendationSummary.
finding Gets the finding of this SqlTuningAdvisorTaskRecommendationSummary.
implement_action_sql Gets the implement_action_sql of this SqlTuningAdvisorTaskRecommendationSummary.
rationale Gets the rationale of this SqlTuningAdvisorTaskRecommendationSummary.
recommendation Gets the recommendation of this SqlTuningAdvisorTaskRecommendationSummary.
recommendation_key [Required] Gets the recommendation_key of this SqlTuningAdvisorTaskRecommendationSummary.
recommendation_type [Required] Gets the recommendation_type of this SqlTuningAdvisorTaskRecommendationSummary.
sql_tuning_advisor_task_id [Required] Gets the sql_tuning_advisor_task_id of this SqlTuningAdvisorTaskRecommendationSummary.
sql_tuning_advisor_task_object_id [Required] Gets the sql_tuning_advisor_task_object_id of this SqlTuningAdvisorTaskRecommendationSummary.

Methods

__init__(**kwargs) Initializes a new SqlTuningAdvisorTaskRecommendationSummary object with values from keyword arguments.
RECOMMENDATION_TYPE_ALTERNATIVE_PLANS = 'ALTERNATIVE_PLANS'

A constant which can be used with the recommendation_type property of a SqlTuningAdvisorTaskRecommendationSummary. This constant has a value of “ALTERNATIVE_PLANS”

RECOMMENDATION_TYPE_ERROR = 'ERROR'

A constant which can be used with the recommendation_type property of a SqlTuningAdvisorTaskRecommendationSummary. This constant has a value of “ERROR”

RECOMMENDATION_TYPE_INDEX = 'INDEX'

A constant which can be used with the recommendation_type property of a SqlTuningAdvisorTaskRecommendationSummary. This constant has a value of “INDEX”

RECOMMENDATION_TYPE_MISCELLANEOUS = 'MISCELLANEOUS'

A constant which can be used with the recommendation_type property of a SqlTuningAdvisorTaskRecommendationSummary. This constant has a value of “MISCELLANEOUS”

RECOMMENDATION_TYPE_RESTRUCTURE_SQL = 'RESTRUCTURE_SQL'

A constant which can be used with the recommendation_type property of a SqlTuningAdvisorTaskRecommendationSummary. This constant has a value of “RESTRUCTURE_SQL”

RECOMMENDATION_TYPE_SQL_PROFILE = 'SQL_PROFILE'

A constant which can be used with the recommendation_type property of a SqlTuningAdvisorTaskRecommendationSummary. This constant has a value of “SQL_PROFILE”

RECOMMENDATION_TYPE_STATISTICS = 'STATISTICS'

A constant which can be used with the recommendation_type property of a SqlTuningAdvisorTaskRecommendationSummary. This constant has a value of “STATISTICS”

__init__(**kwargs)

Initializes a new SqlTuningAdvisorTaskRecommendationSummary object with values from keyword arguments. The following keyword arguments are supported (corresponding to the getters/setters of this class):

Parameters:
  • sql_tuning_advisor_task_id (int) – The value to assign to the sql_tuning_advisor_task_id property of this SqlTuningAdvisorTaskRecommendationSummary.
  • sql_tuning_advisor_task_object_id (int) – The value to assign to the sql_tuning_advisor_task_object_id property of this SqlTuningAdvisorTaskRecommendationSummary.
  • recommendation_key (int) – The value to assign to the recommendation_key property of this SqlTuningAdvisorTaskRecommendationSummary.
  • recommendation_type (str) – The value to assign to the recommendation_type property of this SqlTuningAdvisorTaskRecommendationSummary. Allowed values for this property are: “STATISTICS”, “INDEX”, “SQL_PROFILE”, “RESTRUCTURE_SQL”, “ALTERNATIVE_PLANS”, “ERROR”, “MISCELLANEOUS”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
  • finding (str) – The value to assign to the finding property of this SqlTuningAdvisorTaskRecommendationSummary.
  • recommendation (str) – The value to assign to the recommendation property of this SqlTuningAdvisorTaskRecommendationSummary.
  • rationale (str) – The value to assign to the rationale property of this SqlTuningAdvisorTaskRecommendationSummary.
  • benefit (float) – The value to assign to the benefit property of this SqlTuningAdvisorTaskRecommendationSummary.
  • implement_action_sql (str) – The value to assign to the implement_action_sql property of this SqlTuningAdvisorTaskRecommendationSummary.
benefit

Gets the benefit of this SqlTuningAdvisorTaskRecommendationSummary. The percentage benefit of this implementation.

Returns:The benefit of this SqlTuningAdvisorTaskRecommendationSummary.
Return type:float
finding

Gets the finding of this SqlTuningAdvisorTaskRecommendationSummary. Summary of the issue found for the SQL statement.

Returns:The finding of this SqlTuningAdvisorTaskRecommendationSummary.
Return type:str
implement_action_sql

Gets the implement_action_sql of this SqlTuningAdvisorTaskRecommendationSummary. Action sql to be implemented based on the recommendation result.

Returns:The implement_action_sql of this SqlTuningAdvisorTaskRecommendationSummary.
Return type:str
rationale

Gets the rationale of this SqlTuningAdvisorTaskRecommendationSummary. Describes the reasoning behind the recommendation and how it relates to the finding.

Returns:The rationale of this SqlTuningAdvisorTaskRecommendationSummary.
Return type:str
recommendation

Gets the recommendation of this SqlTuningAdvisorTaskRecommendationSummary. Particular recommendation for the finding.

Returns:The recommendation of this SqlTuningAdvisorTaskRecommendationSummary.
Return type:str
recommendation_key

[Required] Gets the recommendation_key of this SqlTuningAdvisorTaskRecommendationSummary. Unique identifier of the recommendation in the scope of the task.

Returns:The recommendation_key of this SqlTuningAdvisorTaskRecommendationSummary.
Return type:int
recommendation_type

[Required] Gets the recommendation_type of this SqlTuningAdvisorTaskRecommendationSummary. Type of recommendation

Allowed values for this property are: “STATISTICS”, “INDEX”, “SQL_PROFILE”, “RESTRUCTURE_SQL”, “ALTERNATIVE_PLANS”, “ERROR”, “MISCELLANEOUS”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

Returns:The recommendation_type of this SqlTuningAdvisorTaskRecommendationSummary.
Return type:str
sql_tuning_advisor_task_id

[Required] Gets the sql_tuning_advisor_task_id of this SqlTuningAdvisorTaskRecommendationSummary. Unique identifier of the task. It is not the OCID.

Returns:The sql_tuning_advisor_task_id of this SqlTuningAdvisorTaskRecommendationSummary.
Return type:int
sql_tuning_advisor_task_object_id

[Required] Gets the sql_tuning_advisor_task_object_id of this SqlTuningAdvisorTaskRecommendationSummary. Key of the object to which these recommendations apply. It is not the OCID.

Returns:The sql_tuning_advisor_task_object_id of this SqlTuningAdvisorTaskRecommendationSummary.
Return type:int