SqlTuningAdvisorTaskRecommendationSummary¶
- class oci.database_management.models.SqlTuningAdvisorTaskRecommendationSummary(**kwargs)¶
Bases:
objectA recommendation for a given object in a SQL Tuning Task.
Attributes:
A constant which can be used with the recommendation_type property of a SqlTuningAdvisorTaskRecommendationSummary.
A constant which can be used with the recommendation_type property of a SqlTuningAdvisorTaskRecommendationSummary.
A constant which can be used with the recommendation_type property of a SqlTuningAdvisorTaskRecommendationSummary.
A constant which can be used with the recommendation_type property of a SqlTuningAdvisorTaskRecommendationSummary.
A constant which can be used with the recommendation_type property of a SqlTuningAdvisorTaskRecommendationSummary.
A constant which can be used with the recommendation_type property of a SqlTuningAdvisorTaskRecommendationSummary.
A constant which can be used with the recommendation_type property of a SqlTuningAdvisorTaskRecommendationSummary.
Gets the benefit of this SqlTuningAdvisorTaskRecommendationSummary.
Gets the finding of this SqlTuningAdvisorTaskRecommendationSummary.
Gets the implement_action_sql of this SqlTuningAdvisorTaskRecommendationSummary.
Gets the is_parallel_execution of this SqlTuningAdvisorTaskRecommendationSummary.
Gets the rationale of this SqlTuningAdvisorTaskRecommendationSummary.
Gets the recommendation of this SqlTuningAdvisorTaskRecommendationSummary.
[Required] Gets the recommendation_key of this SqlTuningAdvisorTaskRecommendationSummary.
[Required] Gets the recommendation_type of this SqlTuningAdvisorTaskRecommendationSummary.
[Required] Gets the sql_tuning_advisor_task_id of this SqlTuningAdvisorTaskRecommendationSummary.
[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