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.

is_parallel_execution

Gets the is_parallel_execution 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.

  • is_parallel_execution (bool) – The value to assign to the is_parallel_execution property of this SqlTuningAdvisorTaskRecommendationSummary.

property benefit

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

Returns

The benefit of this SqlTuningAdvisorTaskRecommendationSummary.

Return type

float

property finding

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

Returns

The finding of this SqlTuningAdvisorTaskRecommendationSummary.

Return type

str

property 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

property is_parallel_execution

Gets the is_parallel_execution of this SqlTuningAdvisorTaskRecommendationSummary. Indicates whether a SQL Profile recommendation uses parallel execution.

Returns

The is_parallel_execution of this SqlTuningAdvisorTaskRecommendationSummary.

Return type

bool

property 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

property recommendation

Gets the recommendation of this SqlTuningAdvisorTaskRecommendationSummary. The recommendation for a specific finding.

Returns

The recommendation of this SqlTuningAdvisorTaskRecommendationSummary.

Return type

str

property recommendation_key

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

Returns

The recommendation_key of this SqlTuningAdvisorTaskRecommendationSummary.

Return type

int

property 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

property sql_tuning_advisor_task_id

[Required] Gets the sql_tuning_advisor_task_id of this SqlTuningAdvisorTaskRecommendationSummary. The unique identifier of the task. This is not the OCID.

Returns

The sql_tuning_advisor_task_id of this SqlTuningAdvisorTaskRecommendationSummary.

Return type

int

property sql_tuning_advisor_task_object_id

[Required] Gets the sql_tuning_advisor_task_object_id of this SqlTuningAdvisorTaskRecommendationSummary. The key of the object to which these recommendations apply. This is not the OCID.

Returns

The sql_tuning_advisor_task_object_id of this SqlTuningAdvisorTaskRecommendationSummary.

Return type

int