Data Source: oci_database_management_managed_database_sql_tuning_advisor_tasks_recommendations
This data source provides the list of Managed Database Sql Tuning Advisor Tasks Recommendations in Oracle Cloud Infrastructure Database Management service.
Gets the findings and possible actions for a given object in a SQL tuning task. The task ID and object ID are used to retrieve the findings and recommendations.
Example Usage
data "oci_database_management_managed_database_sql_tuning_advisor_tasks_recommendations" "test_managed_database_sql_tuning_advisor_tasks_recommendations" {
#Required
execution_id = oci_database_management_execution.test_execution.id
managed_database_id = oci_database_management_managed_database.test_managed_database.id
sql_object_id = oci_objectstorage_object.test_object.id
sql_tuning_advisor_task_id = oci_database_management_sql_tuning_advisor_task.test_sql_tuning_advisor_task.id
#Optional
opc_named_credential_id = var.managed_database_sql_tuning_advisor_tasks_recommendation_opc_named_credential_id
}
Argument Reference
The following arguments are supported:
execution_id
- (Required) The execution ID for an execution of a SQL tuning task. This is not the OCID.managed_database_id
- (Required) The OCID of the Managed Database.opc_named_credential_id
- (Optional) The OCID of the Named Credential.sql_object_id
- (Required) The SQL object ID for the SQL tuning task. This is not the OCID.sql_tuning_advisor_task_id
- (Required) The SQL tuning task identifier. This is not the OCID.
Attributes Reference
The following attributes are exported:
sql_tuning_advisor_task_recommendation_collection
- The list of sql_tuning_advisor_task_recommendation_collection.
ManagedDatabaseSqlTuningAdvisorTasksRecommendation Reference
The following attributes are exported:
items
- A list of SQL Tuning Advisor recommendations.benefit
- The percentage benefit of this implementation.finding
- Summary of the issue found in the SQL statement.implement_action_sql
- Action sql to be implemented based on the recommendation result.is_parallel_execution
- Indicates whether a SQL Profile recommendation uses parallel execution.rationale
- Describes the reasoning behind the recommendation and how it relates to the finding.recommendation
- The recommendation for a specific finding.recommendation_key
- The unique identifier of the recommendation in the scope of the task.recommendation_type
- Type of recommendation.sql_tuning_advisor_task_id
- The unique identifier of the task. This is not the OCID.sql_tuning_advisor_task_object_id
- The key of the object to which these recommendations apply. This is not the OCID.