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.