Oracle Cloud Infrastructure

v0.5.0 published on Monday, Sep 12, 2022 by Pulumi

getManagedDatabaseSqlTuningAdvisorTasksSummaryReport

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

using System.Collections.Generic;
using Pulumi;
using Oci = Pulumi.Oci;

return await Deployment.RunAsync(() => 
{
    var testManagedDatabaseSqlTuningAdvisorTasksSummaryReport = Oci.DatabaseManagement.GetManagedDatabaseSqlTuningAdvisorTasksSummaryReport.Invoke(new()
    {
        ManagedDatabaseId = oci_database_management_managed_database.Test_managed_database.Id,
        SqlTuningAdvisorTaskId = oci_database_management_sql_tuning_advisor_task.Test_sql_tuning_advisor_task.Id,
        BeginExecIdGreaterThanOrEqualTo = @var.Managed_database_sql_tuning_advisor_tasks_summary_report_begin_exec_id_greater_than_or_equal_to,
        EndExecIdLessThanOrEqualTo = @var.Managed_database_sql_tuning_advisor_tasks_summary_report_end_exec_id_less_than_or_equal_to,
        SearchPeriod = @var.Managed_database_sql_tuning_advisor_tasks_summary_report_search_period,
        TimeGreaterThanOrEqualTo = @var.Managed_database_sql_tuning_advisor_tasks_summary_report_time_greater_than_or_equal_to,
        TimeLessThanOrEqualTo = @var.Managed_database_sql_tuning_advisor_tasks_summary_report_time_less_than_or_equal_to,
    });

});

package main

import (
	"github.com/pulumi/pulumi-oci/sdk/go/oci/DatabaseManagement"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := DatabaseManagement.GetManagedDatabaseSqlTuningAdvisorTasksSummaryReport(ctx, &databasemanagement.GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportArgs{
			ManagedDatabaseId:               oci_database_management_managed_database.Test_managed_database.Id,
			SqlTuningAdvisorTaskId:          oci_database_management_sql_tuning_advisor_task.Test_sql_tuning_advisor_task.Id,
			BeginExecIdGreaterThanOrEqualTo: pulumi.StringRef(_var.Managed_database_sql_tuning_advisor_tasks_summary_report_begin_exec_id_greater_than_or_equal_to),
			EndExecIdLessThanOrEqualTo:      pulumi.StringRef(_var.Managed_database_sql_tuning_advisor_tasks_summary_report_end_exec_id_less_than_or_equal_to),
			SearchPeriod:                    pulumi.StringRef(_var.Managed_database_sql_tuning_advisor_tasks_summary_report_search_period),
			TimeGreaterThanOrEqualTo:        pulumi.StringRef(_var.Managed_database_sql_tuning_advisor_tasks_summary_report_time_greater_than_or_equal_to),
			TimeLessThanOrEqualTo:           pulumi.StringRef(_var.Managed_database_sql_tuning_advisor_tasks_summary_report_time_less_than_or_equal_to),
		}, nil)
		if err != nil {
			return err
		}
		return nil
	})
}

package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.oci.DatabaseManagement.DatabaseManagementFunctions;
import com.pulumi.oci.DatabaseManagement.inputs.GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;

public class App {
    public static void main(String[] args) {
        Pulumi.run(App::stack);
    }

    public static void stack(Context ctx) {
        final var testManagedDatabaseSqlTuningAdvisorTasksSummaryReport = DatabaseManagementFunctions.getManagedDatabaseSqlTuningAdvisorTasksSummaryReport(GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportArgs.builder()
            .managedDatabaseId(oci_database_management_managed_database.test_managed_database().id())
            .sqlTuningAdvisorTaskId(oci_database_management_sql_tuning_advisor_task.test_sql_tuning_advisor_task().id())
            .beginExecIdGreaterThanOrEqualTo(var_.managed_database_sql_tuning_advisor_tasks_summary_report_begin_exec_id_greater_than_or_equal_to())
            .endExecIdLessThanOrEqualTo(var_.managed_database_sql_tuning_advisor_tasks_summary_report_end_exec_id_less_than_or_equal_to())
            .searchPeriod(var_.managed_database_sql_tuning_advisor_tasks_summary_report_search_period())
            .timeGreaterThanOrEqualTo(var_.managed_database_sql_tuning_advisor_tasks_summary_report_time_greater_than_or_equal_to())
            .timeLessThanOrEqualTo(var_.managed_database_sql_tuning_advisor_tasks_summary_report_time_less_than_or_equal_to())
            .build());

    }
}

import pulumi
import pulumi_oci as oci

test_managed_database_sql_tuning_advisor_tasks_summary_report = oci.DatabaseManagement.get_managed_database_sql_tuning_advisor_tasks_summary_report(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"],
    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"],
    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"])

import * as pulumi from "@pulumi/pulumi";
import * as oci from "@pulumi/oci";

const testManagedDatabaseSqlTuningAdvisorTasksSummaryReport = oci.DatabaseManagement.getManagedDatabaseSqlTuningAdvisorTasksSummaryReport({
    managedDatabaseId: oci_database_management_managed_database.test_managed_database.id,
    sqlTuningAdvisorTaskId: oci_database_management_sql_tuning_advisor_task.test_sql_tuning_advisor_task.id,
    beginExecIdGreaterThanOrEqualTo: _var.managed_database_sql_tuning_advisor_tasks_summary_report_begin_exec_id_greater_than_or_equal_to,
    endExecIdLessThanOrEqualTo: _var.managed_database_sql_tuning_advisor_tasks_summary_report_end_exec_id_less_than_or_equal_to,
    searchPeriod: _var.managed_database_sql_tuning_advisor_tasks_summary_report_search_period,
    timeGreaterThanOrEqualTo: _var.managed_database_sql_tuning_advisor_tasks_summary_report_time_greater_than_or_equal_to,
    timeLessThanOrEqualTo: _var.managed_database_sql_tuning_advisor_tasks_summary_report_time_less_than_or_equal_to,
});

variables:
  testManagedDatabaseSqlTuningAdvisorTasksSummaryReport:
    Fn::Invoke:
      Function: oci:DatabaseManagement:getManagedDatabaseSqlTuningAdvisorTasksSummaryReport
      Arguments:
        managedDatabaseId: ${oci_database_management_managed_database.test_managed_database.id}
        sqlTuningAdvisorTaskId: ${oci_database_management_sql_tuning_advisor_task.test_sql_tuning_advisor_task.id}
        beginExecIdGreaterThanOrEqualTo: ${var.managed_database_sql_tuning_advisor_tasks_summary_report_begin_exec_id_greater_than_or_equal_to}
        endExecIdLessThanOrEqualTo: ${var.managed_database_sql_tuning_advisor_tasks_summary_report_end_exec_id_less_than_or_equal_to}
        searchPeriod: ${var.managed_database_sql_tuning_advisor_tasks_summary_report_search_period}
        timeGreaterThanOrEqualTo: ${var.managed_database_sql_tuning_advisor_tasks_summary_report_time_greater_than_or_equal_to}
        timeLessThanOrEqualTo: ${var.managed_database_sql_tuning_advisor_tasks_summary_report_time_less_than_or_equal_to}

Using getManagedDatabaseSqlTuningAdvisorTasksSummaryReport

Two invocation forms are available. The direct form accepts plain arguments and either blocks until the result value is available, or returns a Promise-wrapped result. The output form accepts Input-wrapped arguments and returns an Output-wrapped result.

function getManagedDatabaseSqlTuningAdvisorTasksSummaryReport(args: GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportArgs, opts?: InvokeOptions): Promise<GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportResult>
function getManagedDatabaseSqlTuningAdvisorTasksSummaryReportOutput(args: GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportOutputArgs, opts?: InvokeOptions): Output<GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportResult>

def get_managed_database_sql_tuning_advisor_tasks_summary_report(begin_exec_id_greater_than_or_equal_to: Optional[str] = None,
                                                                 end_exec_id_less_than_or_equal_to: Optional[str] = None,
                                                                 managed_database_id: Optional[str] = None,
                                                                 search_period: Optional[str] = None,
                                                                 sql_tuning_advisor_task_id: Optional[str] = None,
                                                                 time_greater_than_or_equal_to: Optional[str] = None,
                                                                 time_less_than_or_equal_to: Optional[str] = None,
                                                                 opts: Optional[InvokeOptions] = None) -> GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportResult
def get_managed_database_sql_tuning_advisor_tasks_summary_report_output(begin_exec_id_greater_than_or_equal_to: Optional[pulumi.Input[str]] = None,
                                                                 end_exec_id_less_than_or_equal_to: Optional[pulumi.Input[str]] = None,
                                                                 managed_database_id: Optional[pulumi.Input[str]] = None,
                                                                 search_period: Optional[pulumi.Input[str]] = None,
                                                                 sql_tuning_advisor_task_id: Optional[pulumi.Input[str]] = None,
                                                                 time_greater_than_or_equal_to: Optional[pulumi.Input[str]] = None,
                                                                 time_less_than_or_equal_to: Optional[pulumi.Input[str]] = None,
                                                                 opts: Optional[InvokeOptions] = None) -> Output[GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportResult]

func GetManagedDatabaseSqlTuningAdvisorTasksSummaryReport(ctx *Context, args *GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportArgs, opts ...InvokeOption) (*GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportResult, error)
func GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportOutput(ctx *Context, args *GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportOutputArgs, opts ...InvokeOption) GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportResultOutput

> Note: This function is named GetManagedDatabaseSqlTuningAdvisorTasksSummaryReport in the Go SDK.

public static class GetManagedDatabaseSqlTuningAdvisorTasksSummaryReport 
{
    public static Task<GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportResult> InvokeAsync(GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportArgs args, InvokeOptions? opts = null)
    public static Output<GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportResult> Invoke(GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportInvokeArgs args, InvokeOptions? opts = null)
}

public static CompletableFuture<GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportResult> getManagedDatabaseSqlTuningAdvisorTasksSummaryReport(GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportArgs args, InvokeOptions options)
// Output-based functions aren't available in Java yet

Fn::Invoke:
  Function: oci:DatabaseManagement/getManagedDatabaseSqlTuningAdvisorTasksSummaryReport:getManagedDatabaseSqlTuningAdvisorTasksSummaryReport
  Arguments:
    # Arguments dictionary

The following arguments are supported:

ManagedDatabaseId string: The OCID of the Managed Database.
SqlTuningAdvisorTaskId string: The SQL tuning task identifier. This is not the OCID.
BeginExecIdGreaterThanOrEqualTo string: 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.
EndExecIdLessThanOrEqualTo string: 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.
SearchPeriod string: 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.
TimeGreaterThanOrEqualTo string: The optional greater than or equal to query parameter to filter the timestamp. This is applicable only for Auto SQL Tuning tasks.
TimeLessThanOrEqualTo string: The optional less than or equal to query parameter to filter the timestamp. This is applicable only for Auto SQL Tuning tasks.

ManagedDatabaseId string: The OCID of the Managed Database.
SqlTuningAdvisorTaskId string: The SQL tuning task identifier. This is not the OCID.
BeginExecIdGreaterThanOrEqualTo string: 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.
EndExecIdLessThanOrEqualTo string: 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.
SearchPeriod string: 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.
TimeGreaterThanOrEqualTo string: The optional greater than or equal to query parameter to filter the timestamp. This is applicable only for Auto SQL Tuning tasks.
TimeLessThanOrEqualTo string: The optional less than or equal to query parameter to filter the timestamp. This is applicable only for Auto SQL Tuning tasks.

managedDatabaseId String: The OCID of the Managed Database.
sqlTuningAdvisorTaskId String: The SQL tuning task identifier. This is not the OCID.
beginExecIdGreaterThanOrEqualTo String: 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.
endExecIdLessThanOrEqualTo String: 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.
searchPeriod String: 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.
timeGreaterThanOrEqualTo String: The optional greater than or equal to query parameter to filter the timestamp. This is applicable only for Auto SQL Tuning tasks.
timeLessThanOrEqualTo String: The optional less than or equal to query parameter to filter the timestamp. This is applicable only for Auto SQL Tuning tasks.

managedDatabaseId string: The OCID of the Managed Database.
sqlTuningAdvisorTaskId string: The SQL tuning task identifier. This is not the OCID.
beginExecIdGreaterThanOrEqualTo string: 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.
endExecIdLessThanOrEqualTo string: 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.
searchPeriod string: 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.
timeGreaterThanOrEqualTo string: The optional greater than or equal to query parameter to filter the timestamp. This is applicable only for Auto SQL Tuning tasks.
timeLessThanOrEqualTo string: The optional less than or equal to query parameter to filter the timestamp. This is applicable only for Auto SQL Tuning tasks.

managed_database_id str: The OCID of the Managed Database.
sql_tuning_advisor_task_id str: The SQL tuning task identifier. This is not the OCID.
begin_exec_id_greater_than_or_equal_to str: 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 str: 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.
search_period str: 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.
time_greater_than_or_equal_to str: 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 str: The optional less than or equal to query parameter to filter the timestamp. This is applicable only for Auto SQL Tuning tasks.

managedDatabaseId String: The OCID of the Managed Database.
sqlTuningAdvisorTaskId String: The SQL tuning task identifier. This is not the OCID.
beginExecIdGreaterThanOrEqualTo String: 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.
endExecIdLessThanOrEqualTo String: 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.
searchPeriod String: 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.
timeGreaterThanOrEqualTo String: The optional greater than or equal to query parameter to filter the timestamp. This is applicable only for Auto SQL Tuning tasks.
timeLessThanOrEqualTo String: The optional less than or equal to query parameter to filter the timestamp. This is applicable only for Auto SQL Tuning tasks.

getManagedDatabaseSqlTuningAdvisorTasksSummaryReport Result

The following output properties are available:

Id string: The provider-assigned unique ID for this managed resource.
IndexFindings List<GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportIndexFinding>: The list of object findings related to indexes.
ManagedDatabaseId string
ObjectStatFindings List<GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportObjectStatFinding>: The list of object findings related to statistics.
SqlTuningAdvisorTaskId string
Statistics List<GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportStatistic>: The number of distinct SQL statements with stale or missing optimizer statistics recommendations.
TaskInfos List<GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportTaskInfo>: The general information regarding the SQL Tuning Advisor task.
BeginExecIdGreaterThanOrEqualTo string
EndExecIdLessThanOrEqualTo string
SearchPeriod string
TimeGreaterThanOrEqualTo string
TimeLessThanOrEqualTo string

Id string: The provider-assigned unique ID for this managed resource.
IndexFindings []GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportIndexFinding: The list of object findings related to indexes.
ManagedDatabaseId string
ObjectStatFindings []GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportObjectStatFinding: The list of object findings related to statistics.
SqlTuningAdvisorTaskId string
Statistics []GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportStatistic: The number of distinct SQL statements with stale or missing optimizer statistics recommendations.
TaskInfos []GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportTaskInfo: The general information regarding the SQL Tuning Advisor task.
BeginExecIdGreaterThanOrEqualTo string
EndExecIdLessThanOrEqualTo string
SearchPeriod string
TimeGreaterThanOrEqualTo string
TimeLessThanOrEqualTo string

id String: The provider-assigned unique ID for this managed resource.
indexFindings List<GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportIndexFinding>: The list of object findings related to indexes.
managedDatabaseId String
objectStatFindings List<GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportObjectStatFinding>: The list of object findings related to statistics.
sqlTuningAdvisorTaskId String
statistics List<GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportStatistic>: The number of distinct SQL statements with stale or missing optimizer statistics recommendations.
taskInfos List<GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportTaskInfo>: The general information regarding the SQL Tuning Advisor task.
beginExecIdGreaterThanOrEqualTo String
endExecIdLessThanOrEqualTo String
searchPeriod String
timeGreaterThanOrEqualTo String
timeLessThanOrEqualTo String

id string: The provider-assigned unique ID for this managed resource.
indexFindings GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportIndexFinding[]: The list of object findings related to indexes.
managedDatabaseId string
objectStatFindings GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportObjectStatFinding[]: The list of object findings related to statistics.
sqlTuningAdvisorTaskId string
statistics GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportStatistic[]: The number of distinct SQL statements with stale or missing optimizer statistics recommendations.
taskInfos GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportTaskInfo[]: The general information regarding the SQL Tuning Advisor task.
beginExecIdGreaterThanOrEqualTo string
endExecIdLessThanOrEqualTo string
searchPeriod string
timeGreaterThanOrEqualTo string
timeLessThanOrEqualTo string

id str: The provider-assigned unique ID for this managed resource.
index_findings GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportIndexFinding]: The list of object findings related to indexes.
managed_database_id str
object_stat_findings GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportObjectStatFinding]: The list of object findings related to statistics.
sql_tuning_advisor_task_id str
statistics GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportStatistic]: The number of distinct SQL statements with stale or missing optimizer statistics recommendations.
task_infos GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportTaskInfo]: The general information regarding the SQL Tuning Advisor task.
begin_exec_id_greater_than_or_equal_to str
end_exec_id_less_than_or_equal_to str
search_period str
time_greater_than_or_equal_to str
time_less_than_or_equal_to str

id String: The provider-assigned unique ID for this managed resource.
indexFindings List<Property Map>: The list of object findings related to indexes.
managedDatabaseId String
objectStatFindings List<Property Map>: The list of object findings related to statistics.
sqlTuningAdvisorTaskId String
statistics List<Property Map>: The number of distinct SQL statements with stale or missing optimizer statistics recommendations.
taskInfos List<Property Map>: The general information regarding the SQL Tuning Advisor task.
beginExecIdGreaterThanOrEqualTo String
endExecIdLessThanOrEqualTo String
searchPeriod String
timeGreaterThanOrEqualTo String
timeLessThanOrEqualTo String

Supporting Types

GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportIndexFinding

IndexColumns List<string>: Columns of the index.
IndexHashValue string: Numerical representation of the index.
IndexName string: Name of the index.
ReferenceCount int: The number of the times the object is referenced within the SQL Tuning advisor task findings.
Schema string: Schema of the object.
TableName string: Table's name related to the index.

IndexColumns []string: Columns of the index.
IndexHashValue string: Numerical representation of the index.
IndexName string: Name of the index.
ReferenceCount int: The number of the times the object is referenced within the SQL Tuning advisor task findings.
Schema string: Schema of the object.
TableName string: Table's name related to the index.

indexColumns List<String>: Columns of the index.
indexHashValue String: Numerical representation of the index.
indexName String: Name of the index.
referenceCount Integer: The number of the times the object is referenced within the SQL Tuning advisor task findings.
schema String: Schema of the object.
tableName String: Table's name related to the index.

indexColumns string[]: Columns of the index.
indexHashValue string: Numerical representation of the index.
indexName string: Name of the index.
referenceCount number: The number of the times the object is referenced within the SQL Tuning advisor task findings.
schema string: Schema of the object.
tableName string: Table's name related to the index.

index_columns Sequence[str]: Columns of the index.
index_hash_value str: Numerical representation of the index.
index_name str: Name of the index.
reference_count int: The number of the times the object is referenced within the SQL Tuning advisor task findings.
schema str: Schema of the object.
table_name str: Table's name related to the index.

indexColumns List<String>: Columns of the index.
indexHashValue String: Numerical representation of the index.
indexName String: Name of the index.
referenceCount Number: The number of the times the object is referenced within the SQL Tuning advisor task findings.
schema String: Schema of the object.
tableName String: Table's name related to the index.

GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportObjectStatFinding

Object string: Name of the object.
ObjectHashValue string: Numerical representation of the object.
ObjectType string: Type of the object.
ProblemType string: Type of statistics problem related to the object.
ReferenceCount int: The number of the times the object is referenced within the SQL Tuning advisor task findings.
Schema string: Schema of the object.

Object string: Name of the object.
ObjectHashValue string: Numerical representation of the object.
ObjectType string: Type of the object.
ProblemType string: Type of statistics problem related to the object.
ReferenceCount int: The number of the times the object is referenced within the SQL Tuning advisor task findings.
Schema string: Schema of the object.

object String: Name of the object.
objectHashValue String: Numerical representation of the object.
objectType String: Type of the object.
problemType String: Type of statistics problem related to the object.
referenceCount Integer: The number of the times the object is referenced within the SQL Tuning advisor task findings.
schema String: Schema of the object.

object string: Name of the object.
objectHashValue string: Numerical representation of the object.
objectType string: Type of the object.
problemType string: Type of statistics problem related to the object.
referenceCount number: The number of the times the object is referenced within the SQL Tuning advisor task findings.
schema string: Schema of the object.

object str: Name of the object.
object_hash_value str: Numerical representation of the object.
object_type str: Type of the object.
problem_type str: Type of statistics problem related to the object.
reference_count int: The number of the times the object is referenced within the SQL Tuning advisor task findings.
schema str: Schema of the object.

object String: Name of the object.
objectHashValue String: Numerical representation of the object.
objectType String: Type of the object.
problemType String: Type of statistics problem related to the object.
referenceCount Number: The number of the times the object is referenced within the SQL Tuning advisor task findings.
schema String: Schema of the object.

GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportStatistic

FindingBenefits List<GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportStatisticFindingBenefit>: The benefits of the findings in the SQL Tuning Advisor summary report.
FindingCounts List<GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportStatisticFindingCount>: The number of findings in the SQL Tuning Advisor summary report.
StatementCounts List<GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportStatisticStatementCount>: The number of statements in the SQL Tuning Advisor summary report.

FindingBenefits []GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportStatisticFindingBenefit: The benefits of the findings in the SQL Tuning Advisor summary report.
FindingCounts []GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportStatisticFindingCount: The number of findings in the SQL Tuning Advisor summary report.
StatementCounts []GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportStatisticStatementCount: The number of statements in the SQL Tuning Advisor summary report.

findingBenefits List<GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportStatisticFindingBenefit>: The benefits of the findings in the SQL Tuning Advisor summary report.
findingCounts List<GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportStatisticFindingCount>: The number of findings in the SQL Tuning Advisor summary report.
statementCounts List<GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportStatisticStatementCount>: The number of statements in the SQL Tuning Advisor summary report.

findingBenefits GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportStatisticFindingBenefit[]: The benefits of the findings in the SQL Tuning Advisor summary report.
findingCounts GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportStatisticFindingCount[]: The number of findings in the SQL Tuning Advisor summary report.
statementCounts GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportStatisticStatementCount[]: The number of statements in the SQL Tuning Advisor summary report.

finding_benefits GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportStatisticFindingBenefit]: The benefits of the findings in the SQL Tuning Advisor summary report.
finding_counts GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportStatisticFindingCount]: The number of findings in the SQL Tuning Advisor summary report.
statement_counts GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportStatisticStatementCount]: The number of statements in the SQL Tuning Advisor summary report.

findingBenefits List<Property Map>: The benefits of the findings in the SQL Tuning Advisor summary report.
findingCounts List<Property Map>: The number of findings in the SQL Tuning Advisor summary report.
statementCounts List<Property Map>: The number of statements in the SQL Tuning Advisor summary report.

GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportStatisticFindingBenefit

DbTimeAfterImplemented int: The actual database time of the SQL statements for which SQL Tuning Advisor recommendations are implemented.
DbTimeAfterRecommended int: The estimated database time of the above SQL statements, if SQL Tuning Advisor recommendations are implemented.
DbTimeBeforeImplemented int: The actual database time of the above SQL statements, before SQL Tuning Advisor recommendations are implemented.
DbTimeBeforeRecommended int: The actual database time of the SQL statements for which SQL Tuning Advisor recommendations are not implemented.

DbTimeAfterImplemented int: The actual database time of the SQL statements for which SQL Tuning Advisor recommendations are implemented.
DbTimeAfterRecommended int: The estimated database time of the above SQL statements, if SQL Tuning Advisor recommendations are implemented.
DbTimeBeforeImplemented int: The actual database time of the above SQL statements, before SQL Tuning Advisor recommendations are implemented.
DbTimeBeforeRecommended int: The actual database time of the SQL statements for which SQL Tuning Advisor recommendations are not implemented.

dbTimeAfterImplemented Integer: The actual database time of the SQL statements for which SQL Tuning Advisor recommendations are implemented.
dbTimeAfterRecommended Integer: The estimated database time of the above SQL statements, if SQL Tuning Advisor recommendations are implemented.
dbTimeBeforeImplemented Integer: The actual database time of the above SQL statements, before SQL Tuning Advisor recommendations are implemented.
dbTimeBeforeRecommended Integer: The actual database time of the SQL statements for which SQL Tuning Advisor recommendations are not implemented.

dbTimeAfterImplemented number: The actual database time of the SQL statements for which SQL Tuning Advisor recommendations are implemented.
dbTimeAfterRecommended number: The estimated database time of the above SQL statements, if SQL Tuning Advisor recommendations are implemented.
dbTimeBeforeImplemented number: The actual database time of the above SQL statements, before SQL Tuning Advisor recommendations are implemented.
dbTimeBeforeRecommended number: The actual database time of the SQL statements for which SQL Tuning Advisor recommendations are not implemented.

db_time_after_implemented int: The actual database time of the SQL statements for which SQL Tuning Advisor recommendations are implemented.
db_time_after_recommended int: The estimated database time of the above SQL statements, if SQL Tuning Advisor recommendations are implemented.
db_time_before_implemented int: The actual database time of the above SQL statements, before SQL Tuning Advisor recommendations are implemented.
db_time_before_recommended int: The actual database time of the SQL statements for which SQL Tuning Advisor recommendations are not implemented.

dbTimeAfterImplemented Number: The actual database time of the SQL statements for which SQL Tuning Advisor recommendations are implemented.
dbTimeAfterRecommended Number: The estimated database time of the above SQL statements, if SQL Tuning Advisor recommendations are implemented.
dbTimeBeforeImplemented Number: The actual database time of the above SQL statements, before SQL Tuning Advisor recommendations are implemented.
dbTimeBeforeRecommended Number: The actual database time of the SQL statements for which SQL Tuning Advisor recommendations are not implemented.

GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportStatisticFindingCount

AlternatePlan int: The number of distinct SQL statements with alternative plan recommendations.
ImplementedSqlProfile int: The number of distinct SQL statements with implemented SQL profiles.
Index int: The number of distinct SQL statements with index recommendations.
RecommendedSqlProfile int: The number of distinct SQL statements with recommended SQL profiles.
Restructure int: The number of distinct SQL statements with restructured SQL recommendations.
Statistics int: The number of distinct SQL statements with stale or missing optimizer statistics recommendations.

AlternatePlan int: The number of distinct SQL statements with alternative plan recommendations.
ImplementedSqlProfile int: The number of distinct SQL statements with implemented SQL profiles.
Index int: The number of distinct SQL statements with index recommendations.
RecommendedSqlProfile int: The number of distinct SQL statements with recommended SQL profiles.
Restructure int: The number of distinct SQL statements with restructured SQL recommendations.
Statistics int: The number of distinct SQL statements with stale or missing optimizer statistics recommendations.

alternatePlan Integer: The number of distinct SQL statements with alternative plan recommendations.
implementedSqlProfile Integer: The number of distinct SQL statements with implemented SQL profiles.
index Integer: The number of distinct SQL statements with index recommendations.
recommendedSqlProfile Integer: The number of distinct SQL statements with recommended SQL profiles.
restructure Integer: The number of distinct SQL statements with restructured SQL recommendations.
statistics Integer: The number of distinct SQL statements with stale or missing optimizer statistics recommendations.

alternatePlan number: The number of distinct SQL statements with alternative plan recommendations.
implementedSqlProfile number: The number of distinct SQL statements with implemented SQL profiles.
index number: The number of distinct SQL statements with index recommendations.
recommendedSqlProfile number: The number of distinct SQL statements with recommended SQL profiles.
restructure number: The number of distinct SQL statements with restructured SQL recommendations.
statistics number: The number of distinct SQL statements with stale or missing optimizer statistics recommendations.

alternate_plan int: The number of distinct SQL statements with alternative plan recommendations.
implemented_sql_profile int: The number of distinct SQL statements with implemented SQL profiles.
index int: The number of distinct SQL statements with index recommendations.
recommended_sql_profile int: The number of distinct SQL statements with recommended SQL profiles.
restructure int: The number of distinct SQL statements with restructured SQL recommendations.
statistics int: The number of distinct SQL statements with stale or missing optimizer statistics recommendations.

alternatePlan Number: The number of distinct SQL statements with alternative plan recommendations.
implementedSqlProfile Number: The number of distinct SQL statements with implemented SQL profiles.
index Number: The number of distinct SQL statements with index recommendations.
recommendedSqlProfile Number: The number of distinct SQL statements with recommended SQL profiles.
restructure Number: The number of distinct SQL statements with restructured SQL recommendations.
statistics Number: The number of distinct SQL statements with stale or missing optimizer statistics recommendations.

GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportStatisticStatementCount

DistinctSql int: The number of distinct SQL statements.
ErrorCount int: The number of distinct SQL statements with errors.
FindingCount int: The number of distinct SQL statements with findings.
TotalSql int: The total number of SQL statements.

DistinctSql int: The number of distinct SQL statements.
ErrorCount int: The number of distinct SQL statements with errors.
FindingCount int: The number of distinct SQL statements with findings.
TotalSql int: The total number of SQL statements.

distinctSql Integer: The number of distinct SQL statements.
errorCount Integer: The number of distinct SQL statements with errors.
findingCount Integer: The number of distinct SQL statements with findings.
totalSql Integer: The total number of SQL statements.

distinctSql number: The number of distinct SQL statements.
errorCount number: The number of distinct SQL statements with errors.
findingCount number: The number of distinct SQL statements with findings.
totalSql number: The total number of SQL statements.

distinct_sql int: The number of distinct SQL statements.
error_count int: The number of distinct SQL statements with errors.
finding_count int: The number of distinct SQL statements with findings.
total_sql int: The total number of SQL statements.

distinctSql Number: The number of distinct SQL statements.
errorCount Number: The number of distinct SQL statements with errors.
findingCount Number: The number of distinct SQL statements with findings.
totalSql Number: The total number of SQL statements.

GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportTaskInfo

Description string: The description of the SQL Tuning Advisor task. This is not defined for Auto SQL Tuning tasks.
Id string: The ID of the SQL Tuning Advisor task. This is not the OCID.
Name string: The name of the SQL Tuning Advisor task.
Owner string: The owner of the SQL Tuning Advisor task.
RunningTime int: The total running time in seconds. This is not defined for Auto SQL Tuning tasks.
Status string: The status of the SQL Tuning Advisor task. This is not defined for Auto SQL Tuning tasks.
TimeEnded string: The end time of the task execution.
TimeStarted string: The start time of the task execution.

Description string: The description of the SQL Tuning Advisor task. This is not defined for Auto SQL Tuning tasks.
Id string: The ID of the SQL Tuning Advisor task. This is not the OCID.
Name string: The name of the SQL Tuning Advisor task.
Owner string: The owner of the SQL Tuning Advisor task.
RunningTime int: The total running time in seconds. This is not defined for Auto SQL Tuning tasks.
Status string: The status of the SQL Tuning Advisor task. This is not defined for Auto SQL Tuning tasks.
TimeEnded string: The end time of the task execution.
TimeStarted string: The start time of the task execution.

description String: The description of the SQL Tuning Advisor task. This is not defined for Auto SQL Tuning tasks.
id String: The ID of the SQL Tuning Advisor task. This is not the OCID.
name String: The name of the SQL Tuning Advisor task.
owner String: The owner of the SQL Tuning Advisor task.
runningTime Integer: The total running time in seconds. This is not defined for Auto SQL Tuning tasks.
status String: The status of the SQL Tuning Advisor task. This is not defined for Auto SQL Tuning tasks.
timeEnded String: The end time of the task execution.
timeStarted String: The start time of the task execution.

description string: The description of the SQL Tuning Advisor task. This is not defined for Auto SQL Tuning tasks.
id string: The ID of the SQL Tuning Advisor task. This is not the OCID.
name string: The name of the SQL Tuning Advisor task.
owner string: The owner of the SQL Tuning Advisor task.
runningTime number: The total running time in seconds. This is not defined for Auto SQL Tuning tasks.
status string: The status of the SQL Tuning Advisor task. This is not defined for Auto SQL Tuning tasks.
timeEnded string: The end time of the task execution.
timeStarted string: The start time of the task execution.

description str: The description of the SQL Tuning Advisor task. This is not defined for Auto SQL Tuning tasks.
id str: The ID of the SQL Tuning Advisor task. This is not the OCID.
name str: The name of the SQL Tuning Advisor task.
owner str: The owner of the SQL Tuning Advisor task.
running_time int: The total running time in seconds. This is not defined for Auto SQL Tuning tasks.
status str: The status of the SQL Tuning Advisor task. This is not defined for Auto SQL Tuning tasks.
time_ended str: The end time of the task execution.
time_started str: The start time of the task execution.

description String: The description of the SQL Tuning Advisor task. This is not defined for Auto SQL Tuning tasks.
id String: The ID of the SQL Tuning Advisor task. This is not the OCID.
name String: The name of the SQL Tuning Advisor task.
owner String: The owner of the SQL Tuning Advisor task.
runningTime Number: The total running time in seconds. This is not defined for Auto SQL Tuning tasks.
status String: The status of the SQL Tuning Advisor task. This is not defined for Auto SQL Tuning tasks.
timeEnded String: The end time of the task execution.
timeStarted String: The start time of the task execution.

Package Details

Repository: https://github.com/pulumi/pulumi-oci
License: Apache-2.0
Notes: This Pulumi package is based on the oci Terraform Provider.