Data Source: oci_database_management_managed_database_sql_tuning_advisor_task

This data source provides details about a specific Managed Database Sql Tuning Advisor Task resource in Oracle Cloud Infrastructure Database Management service.

Lists the SQL Tuning Advisor tasks for the specified Managed Database.

Example Usage

data "oci_database_management_managed_database_sql_tuning_advisor_task" "test_managed_database_sql_tuning_advisor_task" {
	#Required
	managed_database_id = oci_database_management_managed_database.test_managed_database.id

	#Optional
	name = var.managed_database_sql_tuning_advisor_task_name
	status = var.managed_database_sql_tuning_advisor_task_status
	time_greater_than_or_equal_to = var.managed_database_sql_tuning_advisor_task_time_greater_than_or_equal_to
	time_less_than_or_equal_to = var.managed_database_sql_tuning_advisor_task_time_less_than_or_equal_to
}

Argument Reference

The following arguments are supported:

• managed_database_id - (Required) The OCID of the Managed Database.
• name - (Optional) The optional query parameter to filter the SQL Tuning Advisor task list by name.
• status - (Optional) The optional query parameter to filter the SQL Tuning Advisor task list by status.
• time_greater_than_or_equal_to - (Optional) The optional greater than or equal to query parameter to filter the timestamp.
• time_less_than_or_equal_to - (Optional) The optional less than or equal to query parameter to filter the timestamp.

Attributes Reference

The following attributes are exported:

• items - A list of SQL Tuning Advisor tasks.
  • days_to_expire - The number of days left before the task expires. If the value equals -1, then the task has no expiration time (UNLIMITED).
  • description - The description of the SQL Tuning Advisor task.
  • instance_id - The instance ID of the SQL Tuning Advisor task. This is not the OCID.
  • name - The name of the SQL Tuning Advisor task.
  • owner - The owner of the SQL Tuning Advisor task.
  • recommendation_count - The number of recommendations provided for the SQL Tuning Advisor task.
  • sql_tuning_advisor_task_id - The unique identifier of the SQL Tuning Advisor task. This is not the OCID.
  • task_status - The status of the SQL Tuning Advisor task.
  • time_created - The Creation date of the SQL Tuning Advisor task.
  • time_execution_ended - The end time of the task execution.
  • time_execution_started - The start time of the task execution.
  • total_sql_statements - The total number of SQL statements related to the SQL Tuning Advisor task.