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.

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 in 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

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

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. The recommendation for a specific finding.

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

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

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. The unique identifier of the task. This 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. 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