Data Source: oci_database_management_managed_database_sql_tuning_advisor_tasks_summary_report

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

Gets the summary report for the specified SQL Tuning Advisor task.

Example Usage

data "oci_database_management_managed_database_sql_tuning_advisor_tasks_summary_report" "test_managed_database_sql_tuning_advisor_tasks_summary_report" {
	#Required
	managed_database_id = oci_database_management_managed_database.test_managed_database.id
	sql_tuning_advisor_task_id = oci_database_management_sql_tuning_advisor_task.test_sql_tuning_advisor_task.id

	#Optional
	begin_exec_id_greater_than_or_equal_to = var.managed_database_sql_tuning_advisor_tasks_summary_report_begin_exec_id_greater_than_or_equal_to
	end_exec_id_less_than_or_equal_to = var.managed_database_sql_tuning_advisor_tasks_summary_report_end_exec_id_less_than_or_equal_to
	opc_named_credential_id = var.managed_database_sql_tuning_advisor_tasks_summary_report_opc_named_credential_id
	search_period = var.managed_database_sql_tuning_advisor_tasks_summary_report_search_period
	time_greater_than_or_equal_to = var.managed_database_sql_tuning_advisor_tasks_summary_report_time_greater_than_or_equal_to
	time_less_than_or_equal_to = var.managed_database_sql_tuning_advisor_tasks_summary_report_time_less_than_or_equal_to
}

Argument Reference

The following arguments are supported:

• begin_exec_id_greater_than_or_equal_to - (Optional) The optional greater than or equal to filter on the execution ID related to a specific SQL Tuning Advisor task. This is applicable only for Auto SQL Tuning tasks.
• end_exec_id_less_than_or_equal_to - (Optional) The optional less than or equal to query parameter to filter on the execution ID related to a specific SQL Tuning Advisor task. This is applicable only for Auto SQL Tuning tasks.
• managed_database_id - (Required) The OCID of the Managed Database.
• opc_named_credential_id - (Optional) The OCID of the Named Credential.
• search_period - (Optional) How far back the API will search for begin and end exec id. Unused if neither exec ids nor time filter query params are supplied. This is applicable only for Auto SQL Tuning tasks.
• sql_tuning_advisor_task_id - (Required) The SQL tuning task identifier. This is not the OCID.
• time_greater_than_or_equal_to - (Optional) The optional greater than or equal to query parameter to filter the timestamp. This is applicable only for Auto SQL Tuning tasks.
• time_less_than_or_equal_to - (Optional) The optional less than or equal to query parameter to filter the timestamp. This is applicable only for Auto SQL Tuning tasks.

Attributes Reference

The following attributes are exported:

• index_findings - The list of object findings related to indexes.
  • index_columns - Columns of the index.
  • index_hash_value - Numerical representation of the index.
  • index_name - Name of the index.
  • reference_count - The number of times the index is referenced within the SQL Tuning advisor task findings.
  • schema - Schema related to the index.
  • table_name - Table’s name related to the index.
• object_stat_findings - The list of object findings related to statistics.
  • object - Name of the object.
  • object_hash_value - Numerical representation of the object.
  • object_type - Type of the object.
  • problem_type - Type of statistics problem related to the object.
  • reference_count - The number of the times the object is referenced within the SQL Tuning advisor task findings.
  • schema - Schema of the object.
• statistics - The statistics of the statements and findings in the SQL Tuning Advisor summary report.
  • finding_benefits - The benefits of the findings in the SQL Tuning Advisor summary report.
    • db_time_after_implemented - The actual database time of the SQL statements for which SQL Tuning Advisor recommendations are implemented.
    • db_time_after_recommended - The estimated database time of the above SQL statements, if SQL Tuning Advisor recommendations are implemented.
    • db_time_before_implemented - The actual database time of the above SQL statements, before SQL Tuning Advisor recommendations are implemented.
    • db_time_before_recommended - The actual database time of the SQL statements for which SQL Tuning Advisor recommendations are not implemented.
  • finding_counts - The number of findings in the SQL Tuning Advisor summary report.
    • alternate_plan - The number of distinct SQL statements with alternative plan recommendations.
    • implemented_sql_profile - The number of distinct SQL statements with implemented SQL profiles.
    • index - The number of distinct SQL statements with index recommendations.
    • recommended_sql_profile - The number of distinct SQL statements with recommended SQL profiles.
    • restructure - The number of distinct SQL statements with restructured SQL recommendations.
    • statistics - The number of distinct SQL statements with stale or missing optimizer statistics recommendations.
  • statement_counts - The number of statements in the SQL Tuning Advisor summary report.
    • distinct_sql - The number of distinct SQL statements.
    • error_count - The number of distinct SQL statements with errors.
    • finding_count - The number of distinct SQL statements with findings.
    • total_sql - The total number of SQL statements.
• task_info - The general information regarding the SQL Tuning Advisor task.
  • description - The description of the SQL Tuning Advisor task. This is not defined for Auto SQL Tuning tasks.
  • id - The 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.
  • running_time - The total running time in seconds. This is not defined for Auto SQL Tuning tasks.
  • status - The status of the SQL Tuning Advisor task. This is not defined for Auto SQL Tuning tasks.
  • time_ended - The end time of the task execution.
  • time_started - The start time of the task execution.