Data Source: oci_database_management_managed_database_sql_tuning_sets

This data source provides the list of Managed Database Sql Tuning Sets in Oracle Cloud Infrastructure Database Management service.

Lists the SQL tuning sets for the specified Managed Database.

Example Usage

data "oci_database_management_managed_database_sql_tuning_sets" "test_managed_database_sql_tuning_sets" {
	#Required
	managed_database_id = oci_database_management_managed_database.test_managed_database.id

	#Optional
	name_contains = var.managed_database_sql_tuning_set_name_contains
	opc_named_credential_id = var.managed_database_sql_tuning_set_opc_named_credential_id
	owner = var.managed_database_sql_tuning_set_owner
}

Argument Reference

The following arguments are supported:

• managed_database_id - (Required) The OCID of the Managed Database.
• name_contains - (Optional) Allow searching the name of the SQL tuning set by partial matching. The search is case insensitive.
• opc_named_credential_id - (Optional) The OCID of the Named Credential.
• owner - (Optional) The owner of the SQL tuning set.

Attributes Reference

The following attributes are exported:

• sql_tuning_set_collection - The list of sql_tuning_set_collection.

ManagedDatabaseSqlTuningSet Reference

The following attributes are exported:

• items - The details in the SQL tuning set summary.
  • description - The description of the SQL tuning set.
  • error_message - Latest execution error of the plsql that was submitted as a scheduler job.
  • id - The unique Sql tuning set identifier. This is not OCID.
  • name - The name of the SQL tuning set.
  • owner - The owner of the SQL tuning set.
  • scheduled_job_name - Name of the Sql tuning set scheduler job.
  • statement_counts - The number of SQL statements in the SQL tuning set.
  • status - Current status of the Sql tuning set.
  • time_created - The created time of the Sql tuning set.
  • time_last_modified - Last modified time of the Sql tuning set.
• managed_database_id - The OCID of the Managed Database.