1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. DatabaseManagement
  5. getManagedDatabaseSqlTuningAdvisorTasksSummaryReport
Oracle Cloud Infrastructure v2.3.0 published on Wednesday, Jul 17, 2024 by Pulumi

oci.DatabaseManagement.getManagedDatabaseSqlTuningAdvisorTasksSummaryReport

Explore with Pulumi AI

oci logo
Oracle Cloud Infrastructure v2.3.0 published on Wednesday, Jul 17, 2024 by Pulumi

    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

    import * as pulumi from "@pulumi/pulumi";
    import * as oci from "@pulumi/oci";
    
    const testManagedDatabaseSqlTuningAdvisorTasksSummaryReport = oci.DatabaseManagement.getManagedDatabaseSqlTuningAdvisorTasksSummaryReport({
        managedDatabaseId: testManagedDatabase.id,
        sqlTuningAdvisorTaskId: testSqlTuningAdvisorTask.id,
        beginExecIdGreaterThanOrEqualTo: managedDatabaseSqlTuningAdvisorTasksSummaryReportBeginExecIdGreaterThanOrEqualTo,
        endExecIdLessThanOrEqualTo: managedDatabaseSqlTuningAdvisorTasksSummaryReportEndExecIdLessThanOrEqualTo,
        opcNamedCredentialId: managedDatabaseSqlTuningAdvisorTasksSummaryReportOpcNamedCredentialId,
        searchPeriod: managedDatabaseSqlTuningAdvisorTasksSummaryReportSearchPeriod,
        timeGreaterThanOrEqualTo: managedDatabaseSqlTuningAdvisorTasksSummaryReportTimeGreaterThanOrEqualTo,
        timeLessThanOrEqualTo: managedDatabaseSqlTuningAdvisorTasksSummaryReportTimeLessThanOrEqualTo,
    });
    
    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=test_managed_database["id"],
        sql_tuning_advisor_task_id=test_sql_tuning_advisor_task["id"],
        begin_exec_id_greater_than_or_equal_to=managed_database_sql_tuning_advisor_tasks_summary_report_begin_exec_id_greater_than_or_equal_to,
        end_exec_id_less_than_or_equal_to=managed_database_sql_tuning_advisor_tasks_summary_report_end_exec_id_less_than_or_equal_to,
        opc_named_credential_id=managed_database_sql_tuning_advisor_tasks_summary_report_opc_named_credential_id,
        search_period=managed_database_sql_tuning_advisor_tasks_summary_report_search_period,
        time_greater_than_or_equal_to=managed_database_sql_tuning_advisor_tasks_summary_report_time_greater_than_or_equal_to,
        time_less_than_or_equal_to=managed_database_sql_tuning_advisor_tasks_summary_report_time_less_than_or_equal_to)
    
    package main
    
    import (
    	"github.com/pulumi/pulumi-oci/sdk/v2/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:               testManagedDatabase.Id,
    			SqlTuningAdvisorTaskId:          testSqlTuningAdvisorTask.Id,
    			BeginExecIdGreaterThanOrEqualTo: pulumi.StringRef(managedDatabaseSqlTuningAdvisorTasksSummaryReportBeginExecIdGreaterThanOrEqualTo),
    			EndExecIdLessThanOrEqualTo:      pulumi.StringRef(managedDatabaseSqlTuningAdvisorTasksSummaryReportEndExecIdLessThanOrEqualTo),
    			OpcNamedCredentialId:            pulumi.StringRef(managedDatabaseSqlTuningAdvisorTasksSummaryReportOpcNamedCredentialId),
    			SearchPeriod:                    pulumi.StringRef(managedDatabaseSqlTuningAdvisorTasksSummaryReportSearchPeriod),
    			TimeGreaterThanOrEqualTo:        pulumi.StringRef(managedDatabaseSqlTuningAdvisorTasksSummaryReportTimeGreaterThanOrEqualTo),
    			TimeLessThanOrEqualTo:           pulumi.StringRef(managedDatabaseSqlTuningAdvisorTasksSummaryReportTimeLessThanOrEqualTo),
    		}, nil)
    		if err != nil {
    			return err
    		}
    		return nil
    	})
    }
    
    using System.Collections.Generic;
    using System.Linq;
    using Pulumi;
    using Oci = Pulumi.Oci;
    
    return await Deployment.RunAsync(() => 
    {
        var testManagedDatabaseSqlTuningAdvisorTasksSummaryReport = Oci.DatabaseManagement.GetManagedDatabaseSqlTuningAdvisorTasksSummaryReport.Invoke(new()
        {
            ManagedDatabaseId = testManagedDatabase.Id,
            SqlTuningAdvisorTaskId = testSqlTuningAdvisorTask.Id,
            BeginExecIdGreaterThanOrEqualTo = managedDatabaseSqlTuningAdvisorTasksSummaryReportBeginExecIdGreaterThanOrEqualTo,
            EndExecIdLessThanOrEqualTo = managedDatabaseSqlTuningAdvisorTasksSummaryReportEndExecIdLessThanOrEqualTo,
            OpcNamedCredentialId = managedDatabaseSqlTuningAdvisorTasksSummaryReportOpcNamedCredentialId,
            SearchPeriod = managedDatabaseSqlTuningAdvisorTasksSummaryReportSearchPeriod,
            TimeGreaterThanOrEqualTo = managedDatabaseSqlTuningAdvisorTasksSummaryReportTimeGreaterThanOrEqualTo,
            TimeLessThanOrEqualTo = managedDatabaseSqlTuningAdvisorTasksSummaryReportTimeLessThanOrEqualTo,
        });
    
    });
    
    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(testManagedDatabase.id())
                .sqlTuningAdvisorTaskId(testSqlTuningAdvisorTask.id())
                .beginExecIdGreaterThanOrEqualTo(managedDatabaseSqlTuningAdvisorTasksSummaryReportBeginExecIdGreaterThanOrEqualTo)
                .endExecIdLessThanOrEqualTo(managedDatabaseSqlTuningAdvisorTasksSummaryReportEndExecIdLessThanOrEqualTo)
                .opcNamedCredentialId(managedDatabaseSqlTuningAdvisorTasksSummaryReportOpcNamedCredentialId)
                .searchPeriod(managedDatabaseSqlTuningAdvisorTasksSummaryReportSearchPeriod)
                .timeGreaterThanOrEqualTo(managedDatabaseSqlTuningAdvisorTasksSummaryReportTimeGreaterThanOrEqualTo)
                .timeLessThanOrEqualTo(managedDatabaseSqlTuningAdvisorTasksSummaryReportTimeLessThanOrEqualTo)
                .build());
    
        }
    }
    
    variables:
      testManagedDatabaseSqlTuningAdvisorTasksSummaryReport:
        fn::invoke:
          Function: oci:DatabaseManagement:getManagedDatabaseSqlTuningAdvisorTasksSummaryReport
          Arguments:
            managedDatabaseId: ${testManagedDatabase.id}
            sqlTuningAdvisorTaskId: ${testSqlTuningAdvisorTask.id}
            beginExecIdGreaterThanOrEqualTo: ${managedDatabaseSqlTuningAdvisorTasksSummaryReportBeginExecIdGreaterThanOrEqualTo}
            endExecIdLessThanOrEqualTo: ${managedDatabaseSqlTuningAdvisorTasksSummaryReportEndExecIdLessThanOrEqualTo}
            opcNamedCredentialId: ${managedDatabaseSqlTuningAdvisorTasksSummaryReportOpcNamedCredentialId}
            searchPeriod: ${managedDatabaseSqlTuningAdvisorTasksSummaryReportSearchPeriod}
            timeGreaterThanOrEqualTo: ${managedDatabaseSqlTuningAdvisorTasksSummaryReportTimeGreaterThanOrEqualTo}
            timeLessThanOrEqualTo: ${managedDatabaseSqlTuningAdvisorTasksSummaryReportTimeLessThanOrEqualTo}
    

    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,
                                                                     opc_named_credential_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,
                                                                     opc_named_credential_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.
    OpcNamedCredentialId string
    The OCID of the Named Credential.
    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.
    OpcNamedCredentialId string
    The OCID of the Named Credential.
    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.
    opcNamedCredentialId String
    The OCID of the Named Credential.
    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.
    opcNamedCredentialId string
    The OCID of the Named Credential.
    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.
    opc_named_credential_id str
    The OCID of the Named Credential.
    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.
    opcNamedCredentialId String
    The OCID of the Named Credential.
    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
    OpcNamedCredentialId 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
    OpcNamedCredentialId 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
    opcNamedCredentialId 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
    opcNamedCredentialId string
    searchPeriod string
    timeGreaterThanOrEqualTo string
    timeLessThanOrEqualTo string
    id str
    The provider-assigned unique ID for this managed resource.
    index_findings Sequence[databasemanagement.GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportIndexFinding]
    The list of object findings related to indexes.
    managed_database_id str
    object_stat_findings Sequence[databasemanagement.GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportObjectStatFinding]
    The list of object findings related to statistics.
    sql_tuning_advisor_task_id str
    statistics Sequence[databasemanagement.GetManagedDatabaseSqlTuningAdvisorTasksSummaryReportStatistic]
    The number of distinct SQL statements with stale or missing optimizer statistics recommendations.
    task_infos Sequence[databasemanagement.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
    opc_named_credential_id 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
    opcNamedCredentialId 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.
    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
    oci pulumi/pulumi-oci
    License
    Apache-2.0
    Notes
    This Pulumi package is based on the oci Terraform Provider.
    oci logo
    Oracle Cloud Infrastructure v2.3.0 published on Wednesday, Jul 17, 2024 by Pulumi