Data Source: oci_database_management_managed_database_sql_tuning_advisor_tasks_execution_plan_stats_comparision
This data source provides details about a specific Managed Database Sql Tuning Advisor Tasks Execution Plan Stats Comparision resource in Oracle Cloud Infrastructure Database Management service.
Retrieves a comparison of the existing SQL execution plan and a new plan. A SQL tuning task may suggest a new execution plan for a SQL, and this API retrieves the comparison report of the statistics of the two plans.
Example Usage
data "oci_database_management_managed_database_sql_tuning_advisor_tasks_execution_plan_stats_comparision" "test_managed_database_sql_tuning_advisor_tasks_execution_plan_stats_comparision" {
#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_execution_plan_stats_comparision_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:
modified
- The statistics of a SQL execution plan.plan_stats
- A map contains the statistics for the SQL execution using the plan. The key of the map is the metric’s name. The value of the map is the metric’s value.plan_status
- The status of the execution using the plan.plan_type
- The type of the original or modified plan with profile, index, and so on.
original
- The statistics of a SQL execution plan.plan_stats
- A map contains the statistics for the SQL execution using the plan. The key of the map is the metric’s name. The value of the map is the metric’s value.plan_status
- The status of the execution using the plan.plan_type
- The type of the original or modified plan with profile, index, and so on.