Oracle Cloud Infrastructure

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

getManagedDatabaseSqlTuningAdvisorTasksFindings

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

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

return await Deployment.RunAsync(() => 
{
    var testManagedDatabaseSqlTuningAdvisorTasksFindings = Oci.DatabaseManagement.GetManagedDatabaseSqlTuningAdvisorTasksFindings.Invoke(new()
    {
        ManagedDatabaseId = oci_database_management_managed_database.Test_managed_database.Id,
        SqlTuningAdvisorTaskId = oci_database_management_sql_tuning_advisor_task.Test_sql_tuning_advisor_task.Id,
        BeginExecId = oci_database_management_begin_exec.Test_begin_exec.Id,
        EndExecId = oci_database_management_end_exec.Test_end_exec.Id,
        FindingFilter = @var.Managed_database_sql_tuning_advisor_tasks_finding_finding_filter,
        IndexHashFilter = @var.Managed_database_sql_tuning_advisor_tasks_finding_index_hash_filter,
        SearchPeriod = @var.Managed_database_sql_tuning_advisor_tasks_finding_search_period,
        StatsHashFilter = @var.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:      oci_database_management_managed_database.Test_managed_database.Id,
			SqlTuningAdvisorTaskId: oci_database_management_sql_tuning_advisor_task.Test_sql_tuning_advisor_task.Id,
			BeginExecId:            pulumi.StringRef(oci_database_management_begin_exec.Test_begin_exec.Id),
			EndExecId:              pulumi.StringRef(oci_database_management_end_exec.Test_end_exec.Id),
			FindingFilter:          pulumi.StringRef(_var.Managed_database_sql_tuning_advisor_tasks_finding_finding_filter),
			IndexHashFilter:        pulumi.StringRef(_var.Managed_database_sql_tuning_advisor_tasks_finding_index_hash_filter),
			SearchPeriod:           pulumi.StringRef(_var.Managed_database_sql_tuning_advisor_tasks_finding_search_period),
			StatsHashFilter:        pulumi.StringRef(_var.Managed_database_sql_tuning_advisor_tasks_finding_stats_hash_filter),
		}, nil)
		if err != nil {
			return err
		}
		return nil
	})
}
package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.oci.DatabaseManagement.DatabaseManagementFunctions;
import com.pulumi.oci.DatabaseManagement.inputs.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(oci_database_management_managed_database.test_managed_database().id())
            .sqlTuningAdvisorTaskId(oci_database_management_sql_tuning_advisor_task.test_sql_tuning_advisor_task().id())
            .beginExecId(oci_database_management_begin_exec.test_begin_exec().id())
            .endExecId(oci_database_management_end_exec.test_end_exec().id())
            .findingFilter(var_.managed_database_sql_tuning_advisor_tasks_finding_finding_filter())
            .indexHashFilter(var_.managed_database_sql_tuning_advisor_tasks_finding_index_hash_filter())
            .searchPeriod(var_.managed_database_sql_tuning_advisor_tasks_finding_search_period())
            .statsHashFilter(var_.managed_database_sql_tuning_advisor_tasks_finding_stats_hash_filter())
            .build());

    }
}
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=oci_database_management_managed_database["test_managed_database"]["id"],
    sql_tuning_advisor_task_id=oci_database_management_sql_tuning_advisor_task["test_sql_tuning_advisor_task"]["id"],
    begin_exec_id=oci_database_management_begin_exec["test_begin_exec"]["id"],
    end_exec_id=oci_database_management_end_exec["test_end_exec"]["id"],
    finding_filter=var["managed_database_sql_tuning_advisor_tasks_finding_finding_filter"],
    index_hash_filter=var["managed_database_sql_tuning_advisor_tasks_finding_index_hash_filter"],
    search_period=var["managed_database_sql_tuning_advisor_tasks_finding_search_period"],
    stats_hash_filter=var["managed_database_sql_tuning_advisor_tasks_finding_stats_hash_filter"])
import * as pulumi from "@pulumi/pulumi";
import * as oci from "@pulumi/oci";

const testManagedDatabaseSqlTuningAdvisorTasksFindings = oci.DatabaseManagement.getManagedDatabaseSqlTuningAdvisorTasksFindings({
    managedDatabaseId: oci_database_management_managed_database.test_managed_database.id,
    sqlTuningAdvisorTaskId: oci_database_management_sql_tuning_advisor_task.test_sql_tuning_advisor_task.id,
    beginExecId: oci_database_management_begin_exec.test_begin_exec.id,
    endExecId: oci_database_management_end_exec.test_end_exec.id,
    findingFilter: _var.managed_database_sql_tuning_advisor_tasks_finding_finding_filter,
    indexHashFilter: _var.managed_database_sql_tuning_advisor_tasks_finding_index_hash_filter,
    searchPeriod: _var.managed_database_sql_tuning_advisor_tasks_finding_search_period,
    statsHashFilter: _var.managed_database_sql_tuning_advisor_tasks_finding_stats_hash_filter,
});
variables:
  testManagedDatabaseSqlTuningAdvisorTasksFindings:
    Fn::Invoke:
      Function: oci:DatabaseManagement:getManagedDatabaseSqlTuningAdvisorTasksFindings
      Arguments:
        managedDatabaseId: ${oci_database_management_managed_database.test_managed_database.id}
        sqlTuningAdvisorTaskId: ${oci_database_management_sql_tuning_advisor_task.test_sql_tuning_advisor_task.id}
        beginExecId: ${oci_database_management_begin_exec.test_begin_exec.id}
        endExecId: ${oci_database_management_end_exec.test_end_exec.id}
        findingFilter: ${var.managed_database_sql_tuning_advisor_tasks_finding_finding_filter}
        indexHashFilter: ${var.managed_database_sql_tuning_advisor_tasks_finding_index_hash_filter}
        searchPeriod: ${var.managed_database_sql_tuning_advisor_tasks_finding_search_period}
        statsHashFilter: ${var.managed_database_sql_tuning_advisor_tasks_finding_stats_hash_filter}

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,
                                                           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,
                                                           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.

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.

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.

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.

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 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.

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.

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
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
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
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
searchPeriod string
statsHashFilter string
id str

The provider-assigned unique ID for this managed resource.

managed_database_id str
sql_tuning_advisor_task_finding_collections GetManagedDatabaseSqlTuningAdvisorTasksFindingsSqlTuningAdvisorTaskFindingCollection]

The list of sql_tuning_advisor_task_finding_collection.

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
filters GetManagedDatabaseSqlTuningAdvisorTasksFindingsFilter]
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.

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
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
https://github.com/pulumi/pulumi-oci
License
Apache-2.0
Notes

This Pulumi package is based on the oci Terraform Provider.