Data Source: oci_database_management_managed_database_sql_tuning_advisor_tasks

This data source provides the list of Managed Database Sql Tuning Advisor Tasks 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_tasks" "test_managed_database_sql_tuning_advisor_tasks" {
	#Required
	managed_database_id = oci_database_management_managed_database.test_managed_database.id

	#Optional
	name = var.managed_database_sql_tuning_advisor_task_name
	opc_named_credential_id = var.managed_database_sql_tuning_advisor_task_opc_named_credential_id
	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.
• opc_named_credential_id - (Optional) The OCID of the Named Credential.
• 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:

• sql_tuning_advisor_task_collection - The list of sql_tuning_advisor_task_collection.

ManagedDatabaseSqlTuningAdvisorTask 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.