1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. DatabaseManagement
  5. getManagedDatabaseSqlTuningAdvisorTasksFinding
Oracle Cloud Infrastructure v2.2.0 published on Friday, Jul 12, 2024 by Pulumi

oci.DatabaseManagement.getManagedDatabaseSqlTuningAdvisorTasksFinding

Explore with Pulumi AI

oci logo
Oracle Cloud Infrastructure v2.2.0 published on Friday, Jul 12, 2024 by Pulumi

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

    Gets an array of the details of the findings that match specific filters.

    Example Usage

    import * as pulumi from "@pulumi/pulumi";
    import * as oci from "@pulumi/oci";
    
    const testManagedDatabaseSqlTuningAdvisorTasksFinding = oci.DatabaseManagement.getManagedDatabaseSqlTuningAdvisorTasksFinding({
        managedDatabaseId: testManagedDatabase.id,
        sqlTuningAdvisorTaskId: testSqlTuningAdvisorTask.id,
        beginExecId: testBeginExec.id,
        endExecId: testEndExec.id,
        findingFilter: managedDatabaseSqlTuningAdvisorTasksFindingFindingFilter,
        indexHashFilter: managedDatabaseSqlTuningAdvisorTasksFindingIndexHashFilter,
        searchPeriod: managedDatabaseSqlTuningAdvisorTasksFindingSearchPeriod,
        statsHashFilter: managedDatabaseSqlTuningAdvisorTasksFindingStatsHashFilter,
    });
    
    import pulumi
    import pulumi_oci as oci
    
    test_managed_database_sql_tuning_advisor_tasks_finding = oci.DatabaseManagement.get_managed_database_sql_tuning_advisor_tasks_finding(managed_database_id=test_managed_database["id"],
        sql_tuning_advisor_task_id=test_sql_tuning_advisor_task["id"],
        begin_exec_id=test_begin_exec["id"],
        end_exec_id=test_end_exec["id"],
        finding_filter=managed_database_sql_tuning_advisor_tasks_finding_finding_filter,
        index_hash_filter=managed_database_sql_tuning_advisor_tasks_finding_index_hash_filter,
        search_period=managed_database_sql_tuning_advisor_tasks_finding_search_period,
        stats_hash_filter=managed_database_sql_tuning_advisor_tasks_finding_stats_hash_filter)
    
    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.GetManagedDatabaseSqlTuningAdvisorTasksFinding(ctx, &databasemanagement.GetManagedDatabaseSqlTuningAdvisorTasksFindingArgs{
    			ManagedDatabaseId:      testManagedDatabase.Id,
    			SqlTuningAdvisorTaskId: testSqlTuningAdvisorTask.Id,
    			BeginExecId:            pulumi.StringRef(testBeginExec.Id),
    			EndExecId:              pulumi.StringRef(testEndExec.Id),
    			FindingFilter:          pulumi.StringRef(managedDatabaseSqlTuningAdvisorTasksFindingFindingFilter),
    			IndexHashFilter:        pulumi.StringRef(managedDatabaseSqlTuningAdvisorTasksFindingIndexHashFilter),
    			SearchPeriod:           pulumi.StringRef(managedDatabaseSqlTuningAdvisorTasksFindingSearchPeriod),
    			StatsHashFilter:        pulumi.StringRef(managedDatabaseSqlTuningAdvisorTasksFindingStatsHashFilter),
    		}, 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 testManagedDatabaseSqlTuningAdvisorTasksFinding = Oci.DatabaseManagement.GetManagedDatabaseSqlTuningAdvisorTasksFinding.Invoke(new()
        {
            ManagedDatabaseId = testManagedDatabase.Id,
            SqlTuningAdvisorTaskId = testSqlTuningAdvisorTask.Id,
            BeginExecId = testBeginExec.Id,
            EndExecId = testEndExec.Id,
            FindingFilter = managedDatabaseSqlTuningAdvisorTasksFindingFindingFilter,
            IndexHashFilter = managedDatabaseSqlTuningAdvisorTasksFindingIndexHashFilter,
            SearchPeriod = managedDatabaseSqlTuningAdvisorTasksFindingSearchPeriod,
            StatsHashFilter = managedDatabaseSqlTuningAdvisorTasksFindingStatsHashFilter,
        });
    
    });
    
    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.GetManagedDatabaseSqlTuningAdvisorTasksFindingArgs;
    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 testManagedDatabaseSqlTuningAdvisorTasksFinding = DatabaseManagementFunctions.getManagedDatabaseSqlTuningAdvisorTasksFinding(GetManagedDatabaseSqlTuningAdvisorTasksFindingArgs.builder()
                .managedDatabaseId(testManagedDatabase.id())
                .sqlTuningAdvisorTaskId(testSqlTuningAdvisorTask.id())
                .beginExecId(testBeginExec.id())
                .endExecId(testEndExec.id())
                .findingFilter(managedDatabaseSqlTuningAdvisorTasksFindingFindingFilter)
                .indexHashFilter(managedDatabaseSqlTuningAdvisorTasksFindingIndexHashFilter)
                .searchPeriod(managedDatabaseSqlTuningAdvisorTasksFindingSearchPeriod)
                .statsHashFilter(managedDatabaseSqlTuningAdvisorTasksFindingStatsHashFilter)
                .build());
    
        }
    }
    
    variables:
      testManagedDatabaseSqlTuningAdvisorTasksFinding:
        fn::invoke:
          Function: oci:DatabaseManagement:getManagedDatabaseSqlTuningAdvisorTasksFinding
          Arguments:
            managedDatabaseId: ${testManagedDatabase.id}
            sqlTuningAdvisorTaskId: ${testSqlTuningAdvisorTask.id}
            beginExecId: ${testBeginExec.id}
            endExecId: ${testEndExec.id}
            findingFilter: ${managedDatabaseSqlTuningAdvisorTasksFindingFindingFilter}
            indexHashFilter: ${managedDatabaseSqlTuningAdvisorTasksFindingIndexHashFilter}
            searchPeriod: ${managedDatabaseSqlTuningAdvisorTasksFindingSearchPeriod}
            statsHashFilter: ${managedDatabaseSqlTuningAdvisorTasksFindingStatsHashFilter}
    

    Using getManagedDatabaseSqlTuningAdvisorTasksFinding

    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 getManagedDatabaseSqlTuningAdvisorTasksFinding(args: GetManagedDatabaseSqlTuningAdvisorTasksFindingArgs, opts?: InvokeOptions): Promise<GetManagedDatabaseSqlTuningAdvisorTasksFindingResult>
    function getManagedDatabaseSqlTuningAdvisorTasksFindingOutput(args: GetManagedDatabaseSqlTuningAdvisorTasksFindingOutputArgs, opts?: InvokeOptions): Output<GetManagedDatabaseSqlTuningAdvisorTasksFindingResult>
    def get_managed_database_sql_tuning_advisor_tasks_finding(begin_exec_id: Optional[str] = None,
                                                              end_exec_id: Optional[str] = None,
                                                              finding_filter: Optional[str] = None,
                                                              index_hash_filter: Optional[str] = None,
                                                              managed_database_id: Optional[str] = None,
                                                              search_period: Optional[str] = None,
                                                              sql_tuning_advisor_task_id: Optional[str] = None,
                                                              stats_hash_filter: Optional[str] = None,
                                                              opts: Optional[InvokeOptions] = None) -> GetManagedDatabaseSqlTuningAdvisorTasksFindingResult
    def get_managed_database_sql_tuning_advisor_tasks_finding_output(begin_exec_id: Optional[pulumi.Input[str]] = None,
                                                              end_exec_id: Optional[pulumi.Input[str]] = None,
                                                              finding_filter: Optional[pulumi.Input[str]] = None,
                                                              index_hash_filter: 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,
                                                              stats_hash_filter: Optional[pulumi.Input[str]] = None,
                                                              opts: Optional[InvokeOptions] = None) -> Output[GetManagedDatabaseSqlTuningAdvisorTasksFindingResult]
    func GetManagedDatabaseSqlTuningAdvisorTasksFinding(ctx *Context, args *GetManagedDatabaseSqlTuningAdvisorTasksFindingArgs, opts ...InvokeOption) (*GetManagedDatabaseSqlTuningAdvisorTasksFindingResult, error)
    func GetManagedDatabaseSqlTuningAdvisorTasksFindingOutput(ctx *Context, args *GetManagedDatabaseSqlTuningAdvisorTasksFindingOutputArgs, opts ...InvokeOption) GetManagedDatabaseSqlTuningAdvisorTasksFindingResultOutput

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

    public static class GetManagedDatabaseSqlTuningAdvisorTasksFinding 
    {
        public static Task<GetManagedDatabaseSqlTuningAdvisorTasksFindingResult> InvokeAsync(GetManagedDatabaseSqlTuningAdvisorTasksFindingArgs args, InvokeOptions? opts = null)
        public static Output<GetManagedDatabaseSqlTuningAdvisorTasksFindingResult> Invoke(GetManagedDatabaseSqlTuningAdvisorTasksFindingInvokeArgs args, InvokeOptions? opts = null)
    }
    public static CompletableFuture<GetManagedDatabaseSqlTuningAdvisorTasksFindingResult> getManagedDatabaseSqlTuningAdvisorTasksFinding(GetManagedDatabaseSqlTuningAdvisorTasksFindingArgs args, InvokeOptions options)
    // Output-based functions aren't available in Java yet
    
    fn::invoke:
      function: oci:DatabaseManagement/getManagedDatabaseSqlTuningAdvisorTasksFinding:getManagedDatabaseSqlTuningAdvisorTasksFinding
      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.
    BeginExecId string
    The optional greater than or equal to filter on the execution ID related to a specific SQL Tuning Advisor task.
    EndExecId string
    The optional less than or equal to query parameter to filter on the execution ID related to a specific SQL Tuning Advisor task.
    FindingFilter string
    The filter used to display specific findings in the report.
    IndexHashFilter string
    The hash value of the index table name.
    SearchPeriod string
    The search period during which the API will search for begin and end exec id, if not supplied. Unused if beginExecId and endExecId optional query params are both supplied.
    StatsHashFilter string
    The hash value of the object for the statistic finding search.
    ManagedDatabaseId string
    The OCID of the Managed Database.
    SqlTuningAdvisorTaskId string
    The SQL tuning task identifier. This is not the OCID.
    BeginExecId string
    The optional greater than or equal to filter on the execution ID related to a specific SQL Tuning Advisor task.
    EndExecId string
    The optional less than or equal to query parameter to filter on the execution ID related to a specific SQL Tuning Advisor task.
    FindingFilter string
    The filter used to display specific findings in the report.
    IndexHashFilter string
    The hash value of the index table name.
    SearchPeriod string
    The search period during which the API will search for begin and end exec id, if not supplied. Unused if beginExecId and endExecId optional query params are both supplied.
    StatsHashFilter string
    The hash value of the object for the statistic finding search.
    managedDatabaseId String
    The OCID of the Managed Database.
    sqlTuningAdvisorTaskId String
    The SQL tuning task identifier. This is not the OCID.
    beginExecId String
    The optional greater than or equal to filter on the execution ID related to a specific SQL Tuning Advisor task.
    endExecId String
    The optional less than or equal to query parameter to filter on the execution ID related to a specific SQL Tuning Advisor task.
    findingFilter String
    The filter used to display specific findings in the report.
    indexHashFilter String
    The hash value of the index table name.
    searchPeriod String
    The search period during which the API will search for begin and end exec id, if not supplied. Unused if beginExecId and endExecId optional query params are both supplied.
    statsHashFilter String
    The hash value of the object for the statistic finding search.
    managedDatabaseId string
    The OCID of the Managed Database.
    sqlTuningAdvisorTaskId string
    The SQL tuning task identifier. This is not the OCID.
    beginExecId string
    The optional greater than or equal to filter on the execution ID related to a specific SQL Tuning Advisor task.
    endExecId string
    The optional less than or equal to query parameter to filter on the execution ID related to a specific SQL Tuning Advisor task.
    findingFilter string
    The filter used to display specific findings in the report.
    indexHashFilter string
    The hash value of the index table name.
    searchPeriod string
    The search period during which the API will search for begin and end exec id, if not supplied. Unused if beginExecId and endExecId optional query params are both supplied.
    statsHashFilter string
    The hash value of the object for the statistic finding search.
    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 str
    The optional greater than or equal to filter on the execution ID related to a specific SQL Tuning Advisor task.
    end_exec_id str
    The optional less than or equal to query parameter to filter on the execution ID related to a specific SQL Tuning Advisor task.
    finding_filter str
    The filter used to display specific findings in the report.
    index_hash_filter str
    The hash value of the index table name.
    search_period str
    The search period during which the API will search for begin and end exec id, if not supplied. Unused if beginExecId and endExecId optional query params are both supplied.
    stats_hash_filter str
    The hash value of the object for the statistic finding search.
    managedDatabaseId String
    The OCID of the Managed Database.
    sqlTuningAdvisorTaskId String
    The SQL tuning task identifier. This is not the OCID.
    beginExecId String
    The optional greater than or equal to filter on the execution ID related to a specific SQL Tuning Advisor task.
    endExecId String
    The optional less than or equal to query parameter to filter on the execution ID related to a specific SQL Tuning Advisor task.
    findingFilter String
    The filter used to display specific findings in the report.
    indexHashFilter String
    The hash value of the index table name.
    searchPeriod String
    The search period during which the API will search for begin and end exec id, if not supplied. Unused if beginExecId and endExecId optional query params are both supplied.
    statsHashFilter String
    The hash value of the object for the statistic finding search.

    getManagedDatabaseSqlTuningAdvisorTasksFinding Result

    The following output properties are available:

    Id string
    The provider-assigned unique ID for this managed resource.
    Items List<GetManagedDatabaseSqlTuningAdvisorTasksFindingItem>
    An array of the findings for a tuning task.
    ManagedDatabaseId string
    SqlTuningAdvisorTaskId string
    The unique identifier of the SQL Tuning Advisor task. This is not the OCID.
    BeginExecId string
    EndExecId string
    FindingFilter string
    IndexHashFilter string
    SearchPeriod string
    StatsHashFilter string
    Id string
    The provider-assigned unique ID for this managed resource.
    Items []GetManagedDatabaseSqlTuningAdvisorTasksFindingItem
    An array of the findings for a tuning task.
    ManagedDatabaseId string
    SqlTuningAdvisorTaskId string
    The unique identifier of the SQL Tuning Advisor task. This is not the OCID.
    BeginExecId string
    EndExecId string
    FindingFilter string
    IndexHashFilter string
    SearchPeriod string
    StatsHashFilter string
    id String
    The provider-assigned unique ID for this managed resource.
    items List<GetManagedDatabaseSqlTuningAdvisorTasksFindingItem>
    An array of the findings for a tuning task.
    managedDatabaseId String
    sqlTuningAdvisorTaskId String
    The unique identifier of the SQL Tuning Advisor task. This is not the OCID.
    beginExecId String
    endExecId String
    findingFilter String
    indexHashFilter String
    searchPeriod String
    statsHashFilter String
    id string
    The provider-assigned unique ID for this managed resource.
    items GetManagedDatabaseSqlTuningAdvisorTasksFindingItem[]
    An array of the findings for a tuning task.
    managedDatabaseId string
    sqlTuningAdvisorTaskId string
    The unique identifier of the SQL Tuning Advisor task. This is not the OCID.
    beginExecId string
    endExecId string
    findingFilter string
    indexHashFilter string
    searchPeriod string
    statsHashFilter string
    id str
    The provider-assigned unique ID for this managed resource.
    items Sequence[databasemanagement.GetManagedDatabaseSqlTuningAdvisorTasksFindingItem]
    An array of the findings for a tuning task.
    managed_database_id str
    sql_tuning_advisor_task_id str
    The unique identifier of the SQL Tuning Advisor task. This is not the OCID.
    begin_exec_id str
    end_exec_id str
    finding_filter str
    index_hash_filter str
    search_period str
    stats_hash_filter str
    id String
    The provider-assigned unique ID for this managed resource.
    items List<Property Map>
    An array of the findings for a tuning task.
    managedDatabaseId String
    sqlTuningAdvisorTaskId String
    The unique identifier of the SQL Tuning Advisor task. This is not the OCID.
    beginExecId String
    endExecId String
    findingFilter String
    indexHashFilter String
    searchPeriod String
    statsHashFilter String

    Supporting Types

    GetManagedDatabaseSqlTuningAdvisorTasksFindingItem

    DbTimeBenefit double
    The time benefit (in seconds) for the highest-rated finding for this object.
    IsAlternativePlanFindingPresent bool
    Indicates whether an alternative execution plan was reported for this SQL statement.
    IsErrorFindingPresent bool
    Indicates whether there is an error in this SQL statement.
    IsIndexFindingPresent bool
    Indicates whether an index recommendation was reported for this SQL statement.
    IsMiscellaneousFindingPresent bool
    Indicates whether a miscellaneous finding was reported for this SQL statement.
    IsRestructureSqlFindingPresent bool
    Indicates whether a restructure SQL recommendation was reported for this SQL statement.
    IsSqlProfileFindingImplemented bool
    Indicates whether a SQL Profile recommendation has been implemented for this SQL statement.
    IsSqlProfileFindingPresent bool
    Indicates whether a SQL Profile recommendation was reported for this SQL statement.
    IsStatsFindingPresent bool
    Indicates whether a statistics recommendation was reported for this SQL statement.
    IsTimeoutFindingPresent bool
    Indicates whether the task timed out.
    ParsingSchema string
    The parsing schema of the object.
    PerExecutionPercentage int
    The per-execution percentage benefit.
    SqlKey string
    The unique key of this SQL statement.
    SqlText string
    The text of the SQL statement.
    SqlTuningAdvisorTaskId string
    The SQL tuning task identifier. This is not the OCID.
    SqlTuningAdvisorTaskObjectExecutionId string
    The execution id of the analyzed SQL object. This is not the OCID.
    SqlTuningAdvisorTaskObjectId string
    The key of the object to which these recommendations apply. This is not the OCID.
    DbTimeBenefit float64
    The time benefit (in seconds) for the highest-rated finding for this object.
    IsAlternativePlanFindingPresent bool
    Indicates whether an alternative execution plan was reported for this SQL statement.
    IsErrorFindingPresent bool
    Indicates whether there is an error in this SQL statement.
    IsIndexFindingPresent bool
    Indicates whether an index recommendation was reported for this SQL statement.
    IsMiscellaneousFindingPresent bool
    Indicates whether a miscellaneous finding was reported for this SQL statement.
    IsRestructureSqlFindingPresent bool
    Indicates whether a restructure SQL recommendation was reported for this SQL statement.
    IsSqlProfileFindingImplemented bool
    Indicates whether a SQL Profile recommendation has been implemented for this SQL statement.
    IsSqlProfileFindingPresent bool
    Indicates whether a SQL Profile recommendation was reported for this SQL statement.
    IsStatsFindingPresent bool
    Indicates whether a statistics recommendation was reported for this SQL statement.
    IsTimeoutFindingPresent bool
    Indicates whether the task timed out.
    ParsingSchema string
    The parsing schema of the object.
    PerExecutionPercentage int
    The per-execution percentage benefit.
    SqlKey string
    The unique key of this SQL statement.
    SqlText string
    The text of the SQL statement.
    SqlTuningAdvisorTaskId string
    The SQL tuning task identifier. This is not the OCID.
    SqlTuningAdvisorTaskObjectExecutionId string
    The execution id of the analyzed SQL object. This is not the OCID.
    SqlTuningAdvisorTaskObjectId string
    The key of the object to which these recommendations apply. This is not the OCID.
    dbTimeBenefit Double
    The time benefit (in seconds) for the highest-rated finding for this object.
    isAlternativePlanFindingPresent Boolean
    Indicates whether an alternative execution plan was reported for this SQL statement.
    isErrorFindingPresent Boolean
    Indicates whether there is an error in this SQL statement.
    isIndexFindingPresent Boolean
    Indicates whether an index recommendation was reported for this SQL statement.
    isMiscellaneousFindingPresent Boolean
    Indicates whether a miscellaneous finding was reported for this SQL statement.
    isRestructureSqlFindingPresent Boolean
    Indicates whether a restructure SQL recommendation was reported for this SQL statement.
    isSqlProfileFindingImplemented Boolean
    Indicates whether a SQL Profile recommendation has been implemented for this SQL statement.
    isSqlProfileFindingPresent Boolean
    Indicates whether a SQL Profile recommendation was reported for this SQL statement.
    isStatsFindingPresent Boolean
    Indicates whether a statistics recommendation was reported for this SQL statement.
    isTimeoutFindingPresent Boolean
    Indicates whether the task timed out.
    parsingSchema String
    The parsing schema of the object.
    perExecutionPercentage Integer
    The per-execution percentage benefit.
    sqlKey String
    The unique key of this SQL statement.
    sqlText String
    The text of the SQL statement.
    sqlTuningAdvisorTaskId String
    The SQL tuning task identifier. This is not the OCID.
    sqlTuningAdvisorTaskObjectExecutionId String
    The execution id of the analyzed SQL object. This is not the OCID.
    sqlTuningAdvisorTaskObjectId String
    The key of the object to which these recommendations apply. This is not the OCID.
    dbTimeBenefit number
    The time benefit (in seconds) for the highest-rated finding for this object.
    isAlternativePlanFindingPresent boolean
    Indicates whether an alternative execution plan was reported for this SQL statement.
    isErrorFindingPresent boolean
    Indicates whether there is an error in this SQL statement.
    isIndexFindingPresent boolean
    Indicates whether an index recommendation was reported for this SQL statement.
    isMiscellaneousFindingPresent boolean
    Indicates whether a miscellaneous finding was reported for this SQL statement.
    isRestructureSqlFindingPresent boolean
    Indicates whether a restructure SQL recommendation was reported for this SQL statement.
    isSqlProfileFindingImplemented boolean
    Indicates whether a SQL Profile recommendation has been implemented for this SQL statement.
    isSqlProfileFindingPresent boolean
    Indicates whether a SQL Profile recommendation was reported for this SQL statement.
    isStatsFindingPresent boolean
    Indicates whether a statistics recommendation was reported for this SQL statement.
    isTimeoutFindingPresent boolean
    Indicates whether the task timed out.
    parsingSchema string
    The parsing schema of the object.
    perExecutionPercentage number
    The per-execution percentage benefit.
    sqlKey string
    The unique key of this SQL statement.
    sqlText string
    The text of the SQL statement.
    sqlTuningAdvisorTaskId string
    The SQL tuning task identifier. This is not the OCID.
    sqlTuningAdvisorTaskObjectExecutionId string
    The execution id of the analyzed SQL object. This is not the OCID.
    sqlTuningAdvisorTaskObjectId string
    The key of the object to which these recommendations apply. This is not the OCID.
    db_time_benefit float
    The time benefit (in seconds) for the highest-rated finding for this object.
    is_alternative_plan_finding_present bool
    Indicates whether an alternative execution plan was reported for this SQL statement.
    is_error_finding_present bool
    Indicates whether there is an error in this SQL statement.
    is_index_finding_present bool
    Indicates whether an index recommendation was reported for this SQL statement.
    is_miscellaneous_finding_present bool
    Indicates whether a miscellaneous finding was reported for this SQL statement.
    is_restructure_sql_finding_present bool
    Indicates whether a restructure SQL recommendation was reported for this SQL statement.
    is_sql_profile_finding_implemented bool
    Indicates whether a SQL Profile recommendation has been implemented for this SQL statement.
    is_sql_profile_finding_present bool
    Indicates whether a SQL Profile recommendation was reported for this SQL statement.
    is_stats_finding_present bool
    Indicates whether a statistics recommendation was reported for this SQL statement.
    is_timeout_finding_present bool
    Indicates whether the task timed out.
    parsing_schema str
    The parsing schema of the object.
    per_execution_percentage int
    The per-execution percentage benefit.
    sql_key str
    The unique key of this SQL statement.
    sql_text str
    The text of the SQL statement.
    sql_tuning_advisor_task_id str
    The SQL tuning task identifier. This is not the OCID.
    sql_tuning_advisor_task_object_execution_id str
    The execution id of the analyzed SQL object. This is not the OCID.
    sql_tuning_advisor_task_object_id str
    The key of the object to which these recommendations apply. This is not the OCID.
    dbTimeBenefit Number
    The time benefit (in seconds) for the highest-rated finding for this object.
    isAlternativePlanFindingPresent Boolean
    Indicates whether an alternative execution plan was reported for this SQL statement.
    isErrorFindingPresent Boolean
    Indicates whether there is an error in this SQL statement.
    isIndexFindingPresent Boolean
    Indicates whether an index recommendation was reported for this SQL statement.
    isMiscellaneousFindingPresent Boolean
    Indicates whether a miscellaneous finding was reported for this SQL statement.
    isRestructureSqlFindingPresent Boolean
    Indicates whether a restructure SQL recommendation was reported for this SQL statement.
    isSqlProfileFindingImplemented Boolean
    Indicates whether a SQL Profile recommendation has been implemented for this SQL statement.
    isSqlProfileFindingPresent Boolean
    Indicates whether a SQL Profile recommendation was reported for this SQL statement.
    isStatsFindingPresent Boolean
    Indicates whether a statistics recommendation was reported for this SQL statement.
    isTimeoutFindingPresent Boolean
    Indicates whether the task timed out.
    parsingSchema String
    The parsing schema of the object.
    perExecutionPercentage Number
    The per-execution percentage benefit.
    sqlKey String
    The unique key of this SQL statement.
    sqlText String
    The text of the SQL statement.
    sqlTuningAdvisorTaskId String
    The SQL tuning task identifier. This is not the OCID.
    sqlTuningAdvisorTaskObjectExecutionId String
    The execution id of the analyzed SQL object. This is not the OCID.
    sqlTuningAdvisorTaskObjectId String
    The key of the object to which these recommendations apply. This is not the OCID.

    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.2.0 published on Friday, Jul 12, 2024 by Pulumi