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.