Docs Packages
  1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. DatabaseManagement
  5. getManagedDatabaseSqlTuningAdvisorTasksFindings
Oracle Cloud Infrastructure v1.33.0 published on Thursday, Apr 25, 2024 by Pulumi
pulumi/pulumi-oci

oci.DatabaseManagement.getManagedDatabaseSqlTuningAdvisorTasksFindings

Explore with Pulumi AI

oci logo
Oracle Cloud Infrastructure v1.33.0 published on Thursday, Apr 25, 2024 by Pulumi
pulumi/pulumi-oci

    This data source provides the list of Managed Database Sql Tuning Advisor Tasks Findings 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 testManagedDatabaseSqlTuningAdvisorTasksFindings = oci.DatabaseManagement.getManagedDatabaseSqlTuningAdvisorTasksFindings({
    managedDatabaseId: testManagedDatabase.id,
    sqlTuningAdvisorTaskId: testSqlTuningAdvisorTask.id,
    beginExecId: testBeginExec.id,
    endExecId: testEndExec.id,
    findingFilter: managedDatabaseSqlTuningAdvisorTasksFindingFindingFilter,
    indexHashFilter: managedDatabaseSqlTuningAdvisorTasksFindingIndexHashFilter,
    opcNamedCredentialId: managedDatabaseSqlTuningAdvisorTasksFindingOpcNamedCredentialId,
    searchPeriod: managedDatabaseSqlTuningAdvisorTasksFindingSearchPeriod,
    statsHashFilter: managedDatabaseSqlTuningAdvisorTasksFindingStatsHashFilter,
});

    import pulumi
import pulumi_oci as oci

test_managed_database_sql_tuning_advisor_tasks_findings = oci.DatabaseManagement.get_managed_database_sql_tuning_advisor_tasks_findings(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,
    opc_named_credential_id=managed_database_sql_tuning_advisor_tasks_finding_opc_named_credential_id,
    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/go/oci/DatabaseManagement"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := DatabaseManagement.GetManagedDatabaseSqlTuningAdvisorTasksFindings(ctx, &databasemanagement.GetManagedDatabaseSqlTuningAdvisorTasksFindingsArgs{
			ManagedDatabaseId:      testManagedDatabase.Id,
			SqlTuningAdvisorTaskId: testSqlTuningAdvisorTask.Id,
			BeginExecId:            pulumi.StringRef(testBeginExec.Id),
			EndExecId:              pulumi.StringRef(testEndExec.Id),
			FindingFilter:          pulumi.StringRef(managedDatabaseSqlTuningAdvisorTasksFindingFindingFilter),
			IndexHashFilter:        pulumi.StringRef(managedDatabaseSqlTuningAdvisorTasksFindingIndexHashFilter),
			OpcNamedCredentialId:   pulumi.StringRef(managedDatabaseSqlTuningAdvisorTasksFindingOpcNamedCredentialId),
			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 testManagedDatabaseSqlTuningAdvisorTasksFindings = Oci.DatabaseManagement.GetManagedDatabaseSqlTuningAdvisorTasksFindings.Invoke(new()
    {
        ManagedDatabaseId = testManagedDatabase.Id,
        SqlTuningAdvisorTaskId = testSqlTuningAdvisorTask.Id,
        BeginExecId = testBeginExec.Id,
        EndExecId = testEndExec.Id,
        FindingFilter = managedDatabaseSqlTuningAdvisorTasksFindingFindingFilter,
        IndexHashFilter = managedDatabaseSqlTuningAdvisorTasksFindingIndexHashFilter,
        OpcNamedCredentialId = managedDatabaseSqlTuningAdvisorTasksFindingOpcNamedCredentialId,
        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.GetManagedDatabaseSqlTuningAdvisorTasksFindingsArgs;
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 testManagedDatabaseSqlTuningAdvisorTasksFindings = DatabaseManagementFunctions.getManagedDatabaseSqlTuningAdvisorTasksFindings(GetManagedDatabaseSqlTuningAdvisorTasksFindingsArgs.builder()
            .managedDatabaseId(testManagedDatabase.id())
            .sqlTuningAdvisorTaskId(testSqlTuningAdvisorTask.id())
            .beginExecId(testBeginExec.id())
            .endExecId(testEndExec.id())
            .findingFilter(managedDatabaseSqlTuningAdvisorTasksFindingFindingFilter)
            .indexHashFilter(managedDatabaseSqlTuningAdvisorTasksFindingIndexHashFilter)
            .opcNamedCredentialId(managedDatabaseSqlTuningAdvisorTasksFindingOpcNamedCredentialId)
            .searchPeriod(managedDatabaseSqlTuningAdvisorTasksFindingSearchPeriod)
            .statsHashFilter(managedDatabaseSqlTuningAdvisorTasksFindingStatsHashFilter)
            .build());

    }
}

    variables:
  testManagedDatabaseSqlTuningAdvisorTasksFindings:
    fn::invoke:
      Function: oci:DatabaseManagement:getManagedDatabaseSqlTuningAdvisorTasksFindings
      Arguments:
        managedDatabaseId: ${testManagedDatabase.id}
        sqlTuningAdvisorTaskId: ${testSqlTuningAdvisorTask.id}
        beginExecId: ${testBeginExec.id}
        endExecId: ${testEndExec.id}
        findingFilter: ${managedDatabaseSqlTuningAdvisorTasksFindingFindingFilter}
        indexHashFilter: ${managedDatabaseSqlTuningAdvisorTasksFindingIndexHashFilter}
        opcNamedCredentialId: ${managedDatabaseSqlTuningAdvisorTasksFindingOpcNamedCredentialId}
        searchPeriod: ${managedDatabaseSqlTuningAdvisorTasksFindingSearchPeriod}
        statsHashFilter: ${managedDatabaseSqlTuningAdvisorTasksFindingStatsHashFilter}

    Using getManagedDatabaseSqlTuningAdvisorTasksFindings

    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 getManagedDatabaseSqlTuningAdvisorTasksFindings(args: GetManagedDatabaseSqlTuningAdvisorTasksFindingsArgs, opts?: InvokeOptions): Promise<GetManagedDatabaseSqlTuningAdvisorTasksFindingsResult>
function getManagedDatabaseSqlTuningAdvisorTasksFindingsOutput(args: GetManagedDatabaseSqlTuningAdvisorTasksFindingsOutputArgs, opts?: InvokeOptions): Output<GetManagedDatabaseSqlTuningAdvisorTasksFindingsResult>
    def get_managed_database_sql_tuning_advisor_tasks_findings(begin_exec_id: Optional[str] = None,
                                                           end_exec_id: Optional[str] = None,
                                                           filters: Optional[Sequence[_databasemanagement.GetManagedDatabaseSqlTuningAdvisorTasksFindingsFilter]] = None,
                                                           finding_filter: Optional[str] = None,
                                                           index_hash_filter: 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,
                                                           stats_hash_filter: Optional[str] = None,
                                                           opts: Optional[InvokeOptions] = None) -> GetManagedDatabaseSqlTuningAdvisorTasksFindingsResult
def get_managed_database_sql_tuning_advisor_tasks_findings_output(begin_exec_id: Optional[pulumi.Input[str]] = None,
                                                           end_exec_id: Optional[pulumi.Input[str]] = None,
                                                           filters: Optional[pulumi.Input[Sequence[pulumi.Input[_databasemanagement.GetManagedDatabaseSqlTuningAdvisorTasksFindingsFilterArgs]]]] = None,
                                                           finding_filter: Optional[pulumi.Input[str]] = None,
                                                           index_hash_filter: 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,
                                                           stats_hash_filter: Optional[pulumi.Input[str]] = None,
                                                           opts: Optional[InvokeOptions] = None) -> Output[GetManagedDatabaseSqlTuningAdvisorTasksFindingsResult]
    func GetManagedDatabaseSqlTuningAdvisorTasksFindings(ctx *Context, args *GetManagedDatabaseSqlTuningAdvisorTasksFindingsArgs, opts ...InvokeOption) (*GetManagedDatabaseSqlTuningAdvisorTasksFindingsResult, error)
func GetManagedDatabaseSqlTuningAdvisorTasksFindingsOutput(ctx *Context, args *GetManagedDatabaseSqlTuningAdvisorTasksFindingsOutputArgs, opts ...InvokeOption) GetManagedDatabaseSqlTuningAdvisorTasksFindingsResultOutput

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

    public static class GetManagedDatabaseSqlTuningAdvisorTasksFindings 
{
    public static Task<GetManagedDatabaseSqlTuningAdvisorTasksFindingsResult> InvokeAsync(GetManagedDatabaseSqlTuningAdvisorTasksFindingsArgs args, InvokeOptions? opts = null)
    public static Output<GetManagedDatabaseSqlTuningAdvisorTasksFindingsResult> Invoke(GetManagedDatabaseSqlTuningAdvisorTasksFindingsInvokeArgs args, InvokeOptions? opts = null)
}
    public static CompletableFuture<GetManagedDatabaseSqlTuningAdvisorTasksFindingsResult> getManagedDatabaseSqlTuningAdvisorTasksFindings(GetManagedDatabaseSqlTuningAdvisorTasksFindingsArgs args, InvokeOptions options)
// Output-based functions aren't available in Java yet

    fn::invoke:
  function: oci:DatabaseManagement/getManagedDatabaseSqlTuningAdvisorTasksFindings:getManagedDatabaseSqlTuningAdvisorTasksFindings
  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.
    Filters List<GetManagedDatabaseSqlTuningAdvisorTasksFindingsFilter>
    FindingFilter string
    The filter used to display specific findings in the report.
    IndexHashFilter string
    The hash value of the index table name.
    OpcNamedCredentialId string
    The OCID of the Named Credential.
    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.
    Filters []GetManagedDatabaseSqlTuningAdvisorTasksFindingsFilter
    FindingFilter string
    The filter used to display specific findings in the report.
    IndexHashFilter string
    The hash value of the index table name.
    OpcNamedCredentialId string
    The OCID of the Named Credential.
    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.
    filters List<GetManagedDatabaseSqlTuningAdvisorTasksFindingsFilter>
    findingFilter String
    The filter used to display specific findings in the report.
    indexHashFilter String
    The hash value of the index table name.
    opcNamedCredentialId String
    The OCID of the Named Credential.
    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.
    filters GetManagedDatabaseSqlTuningAdvisorTasksFindingsFilter[]
    findingFilter string
    The filter used to display specific findings in the report.
    indexHashFilter string
    The hash value of the index table name.
    opcNamedCredentialId string
    The OCID of the Named Credential.
    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.
    filters Sequence[databasemanagement.GetManagedDatabaseSqlTuningAdvisorTasksFindingsFilter]
    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.
    opc_named_credential_id str
    The OCID of the Named Credential.
    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.
    filters List<Property Map>
    findingFilter String
    The filter used to display specific findings in the report.
    indexHashFilter String
    The hash value of the index table name.
    opcNamedCredentialId String
    The OCID of the Named Credential.
    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.

    getManagedDatabaseSqlTuningAdvisorTasksFindings Result

    The following output properties are available:

    Id string
    The provider-assigned unique ID for this managed resource.
    ManagedDatabaseId string
    SqlTuningAdvisorTaskFindingCollections List<GetManagedDatabaseSqlTuningAdvisorTasksFindingsSqlTuningAdvisorTaskFindingCollection>
    The list of sql_tuning_advisor_task_finding_collection.
    SqlTuningAdvisorTaskId string
    The unique identifier of the SQL Tuning Advisor task. This is not the OCID.
    BeginExecId string
    EndExecId string
    Filters List<GetManagedDatabaseSqlTuningAdvisorTasksFindingsFilter>
    FindingFilter string
    IndexHashFilter string
    OpcNamedCredentialId string
    SearchPeriod string
    StatsHashFilter string
    Id string
    The provider-assigned unique ID for this managed resource.
    ManagedDatabaseId string
    SqlTuningAdvisorTaskFindingCollections []GetManagedDatabaseSqlTuningAdvisorTasksFindingsSqlTuningAdvisorTaskFindingCollection
    The list of sql_tuning_advisor_task_finding_collection.
    SqlTuningAdvisorTaskId string
    The unique identifier of the SQL Tuning Advisor task. This is not the OCID.
    BeginExecId string
    EndExecId string
    Filters []GetManagedDatabaseSqlTuningAdvisorTasksFindingsFilter
    FindingFilter string
    IndexHashFilter string
    OpcNamedCredentialId string
    SearchPeriod string
    StatsHashFilter string
    id String
    The provider-assigned unique ID for this managed resource.
    managedDatabaseId String
    sqlTuningAdvisorTaskFindingCollections List<GetManagedDatabaseSqlTuningAdvisorTasksFindingsSqlTuningAdvisorTaskFindingCollection>
    The list of sql_tuning_advisor_task_finding_collection.
    sqlTuningAdvisorTaskId String
    The unique identifier of the SQL Tuning Advisor task. This is not the OCID.
    beginExecId String
    endExecId String
    filters List<GetManagedDatabaseSqlTuningAdvisorTasksFindingsFilter>
    findingFilter String
    indexHashFilter String
    opcNamedCredentialId String
    searchPeriod String
    statsHashFilter String
    id string
    The provider-assigned unique ID for this managed resource.
    managedDatabaseId string
    sqlTuningAdvisorTaskFindingCollections GetManagedDatabaseSqlTuningAdvisorTasksFindingsSqlTuningAdvisorTaskFindingCollection[]
    The list of sql_tuning_advisor_task_finding_collection.
    sqlTuningAdvisorTaskId string
    The unique identifier of the SQL Tuning Advisor task. This is not the OCID.
    beginExecId string
    endExecId string
    filters GetManagedDatabaseSqlTuningAdvisorTasksFindingsFilter[]
    findingFilter string
    indexHashFilter string
    opcNamedCredentialId string
    searchPeriod string
    statsHashFilter string
    id String
    The provider-assigned unique ID for this managed resource.
    managedDatabaseId String
    sqlTuningAdvisorTaskFindingCollections List<Property Map>
    The list of sql_tuning_advisor_task_finding_collection.
    sqlTuningAdvisorTaskId String
    The unique identifier of the SQL Tuning Advisor task. This is not the OCID.
    beginExecId String
    endExecId String
    filters List<Property Map>
    findingFilter String
    indexHashFilter String
    opcNamedCredentialId String
    searchPeriod String
    statsHashFilter String

    Supporting Types

    GetManagedDatabaseSqlTuningAdvisorTasksFindingsFilter

    Name string
    Values List<string>
    Regex bool
    Name string
    Values []string
    Regex bool
    name String
    values List<String>
    regex Boolean
    name string
    values string[]
    regex boolean
    name str
    values Sequence[str]
    regex bool
    name String
    values List<String>
    regex Boolean

    GetManagedDatabaseSqlTuningAdvisorTasksFindingsSqlTuningAdvisorTaskFindingCollection

    items List<Property Map>
    An array of the findings for a tuning task.

    GetManagedDatabaseSqlTuningAdvisorTasksFindingsSqlTuningAdvisorTaskFindingCollectionItem

    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 v1.33.0 published on Thursday, Apr 25, 2024 by Pulumi
    pulumi/pulumi-oci