Oracle Cloud Infrastructure

Pulumi Official
Package maintained by Pulumi
v0.1.1 published on Tuesday, May 3, 2022 by Pulumi

getManagedDatabaseSqlTuningAdvisorTasksRecommendation

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

Gets the findings and possible actions for a given object in a SQL tuning task. The task ID and object ID are used to retrieve the findings and recommendations.

Example Usage

using Pulumi;
using Oci = Pulumi.Oci;

class MyStack : Stack
{
    public MyStack()
    {
        var testManagedDatabaseSqlTuningAdvisorTasksRecommendation = Output.Create(Oci.DatabaseManagement.GetManagedDatabaseSqlTuningAdvisorTasksRecommendation.InvokeAsync(new Oci.DatabaseManagement.GetManagedDatabaseSqlTuningAdvisorTasksRecommendationArgs
        {
            ExecutionId = oci_database_management_execution.Test_execution.Id,
            ManagedDatabaseId = oci_database_management_managed_database.Test_managed_database.Id,
            SqlObjectId = oci_objectstorage_object.Test_object.Id,
            SqlTuningAdvisorTaskId = oci_database_management_sql_tuning_advisor_task.Test_sql_tuning_advisor_task.Id,
        }));
    }

}
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.GetManagedDatabaseSqlTuningAdvisorTasksRecommendation(ctx, &databasemanagement.GetManagedDatabaseSqlTuningAdvisorTasksRecommendationArgs{
			ExecutionId:            oci_database_management_execution.Test_execution.Id,
			ManagedDatabaseId:      oci_database_management_managed_database.Test_managed_database.Id,
			SqlObjectId:            oci_objectstorage_object.Test_object.Id,
			SqlTuningAdvisorTaskId: oci_database_management_sql_tuning_advisor_task.Test_sql_tuning_advisor_task.Id,
		}, nil)
		if err != nil {
			return err
		}
		return nil
	})
}

Coming soon!

import pulumi
import pulumi_oci as oci

test_managed_database_sql_tuning_advisor_tasks_recommendation = oci.DatabaseManagement.get_managed_database_sql_tuning_advisor_tasks_recommendation(execution_id=oci_database_management_execution["test_execution"]["id"],
    managed_database_id=oci_database_management_managed_database["test_managed_database"]["id"],
    sql_object_id=oci_objectstorage_object["test_object"]["id"],
    sql_tuning_advisor_task_id=oci_database_management_sql_tuning_advisor_task["test_sql_tuning_advisor_task"]["id"])
import * as pulumi from "@pulumi/pulumi";
import * as oci from "@pulumi/oci";

const testManagedDatabaseSqlTuningAdvisorTasksRecommendation = oci.DatabaseManagement.getManagedDatabaseSqlTuningAdvisorTasksRecommendation({
    executionId: oci_database_management_execution.test_execution.id,
    managedDatabaseId: oci_database_management_managed_database.test_managed_database.id,
    sqlObjectId: oci_objectstorage_object.test_object.id,
    sqlTuningAdvisorTaskId: oci_database_management_sql_tuning_advisor_task.test_sql_tuning_advisor_task.id,
});

Coming soon!

Using getManagedDatabaseSqlTuningAdvisorTasksRecommendation

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 getManagedDatabaseSqlTuningAdvisorTasksRecommendation(args: GetManagedDatabaseSqlTuningAdvisorTasksRecommendationArgs, opts?: InvokeOptions): Promise<GetManagedDatabaseSqlTuningAdvisorTasksRecommendationResult>
function getManagedDatabaseSqlTuningAdvisorTasksRecommendationOutput(args: GetManagedDatabaseSqlTuningAdvisorTasksRecommendationOutputArgs, opts?: InvokeOptions): Output<GetManagedDatabaseSqlTuningAdvisorTasksRecommendationResult>
def get_managed_database_sql_tuning_advisor_tasks_recommendation(execution_id: Optional[str] = None,
                                                                 managed_database_id: Optional[str] = None,
                                                                 sql_object_id: Optional[str] = None,
                                                                 sql_tuning_advisor_task_id: Optional[str] = None,
                                                                 opts: Optional[InvokeOptions] = None) -> GetManagedDatabaseSqlTuningAdvisorTasksRecommendationResult
def get_managed_database_sql_tuning_advisor_tasks_recommendation_output(execution_id: Optional[pulumi.Input[str]] = None,
                                                                 managed_database_id: Optional[pulumi.Input[str]] = None,
                                                                 sql_object_id: Optional[pulumi.Input[str]] = None,
                                                                 sql_tuning_advisor_task_id: Optional[pulumi.Input[str]] = None,
                                                                 opts: Optional[InvokeOptions] = None) -> Output[GetManagedDatabaseSqlTuningAdvisorTasksRecommendationResult]
func GetManagedDatabaseSqlTuningAdvisorTasksRecommendation(ctx *Context, args *GetManagedDatabaseSqlTuningAdvisorTasksRecommendationArgs, opts ...InvokeOption) (*GetManagedDatabaseSqlTuningAdvisorTasksRecommendationResult, error)
func GetManagedDatabaseSqlTuningAdvisorTasksRecommendationOutput(ctx *Context, args *GetManagedDatabaseSqlTuningAdvisorTasksRecommendationOutputArgs, opts ...InvokeOption) GetManagedDatabaseSqlTuningAdvisorTasksRecommendationResultOutput

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

public static class GetManagedDatabaseSqlTuningAdvisorTasksRecommendation 
{
    public static Task<GetManagedDatabaseSqlTuningAdvisorTasksRecommendationResult> InvokeAsync(GetManagedDatabaseSqlTuningAdvisorTasksRecommendationArgs args, InvokeOptions? opts = null)
    public static Output<GetManagedDatabaseSqlTuningAdvisorTasksRecommendationResult> Invoke(GetManagedDatabaseSqlTuningAdvisorTasksRecommendationInvokeArgs args, InvokeOptions? opts = null)
}
public static CompletableFuture<GetManagedDatabaseSqlTuningAdvisorTasksRecommendationResult> getManagedDatabaseSqlTuningAdvisorTasksRecommendation(GetManagedDatabaseSqlTuningAdvisorTasksRecommendationArgs args, InvokeOptions options)
// Output-based functions aren't available in Java yet
Fn::Invoke:
  Function: oci:DatabaseManagement/getManagedDatabaseSqlTuningAdvisorTasksRecommendation:getManagedDatabaseSqlTuningAdvisorTasksRecommendation
  Arguments:
    # Arguments dictionary

The following arguments are supported:

ExecutionId string

The execution ID for an execution of a SQL tuning task. This is not the OCID.

ManagedDatabaseId string

The OCID of the Managed Database.

SqlObjectId string

The SQL object ID for the SQL tuning task. This is not the OCID.

SqlTuningAdvisorTaskId string

The SQL tuning task identifier. This is not the OCID.

ExecutionId string

The execution ID for an execution of a SQL tuning task. This is not the OCID.

ManagedDatabaseId string

The OCID of the Managed Database.

SqlObjectId string

The SQL object ID for the SQL tuning task. This is not the OCID.

SqlTuningAdvisorTaskId string

The SQL tuning task identifier. This is not the OCID.

executionId String

The execution ID for an execution of a SQL tuning task. This is not the OCID.

managedDatabaseId String

The OCID of the Managed Database.

sqlObjectId String

The SQL object ID for the SQL tuning task. This is not the OCID.

sqlTuningAdvisorTaskId String

The SQL tuning task identifier. This is not the OCID.

executionId string

The execution ID for an execution of a SQL tuning task. This is not the OCID.

managedDatabaseId string

The OCID of the Managed Database.

sqlObjectId string

The SQL object ID for the SQL tuning task. This is not the OCID.

sqlTuningAdvisorTaskId string

The SQL tuning task identifier. This is not the OCID.

execution_id str

The execution ID for an execution of a SQL tuning task. This is not the OCID.

managed_database_id str

The OCID of the Managed Database.

sql_object_id str

The SQL object ID for the SQL tuning task. This is not the OCID.

sql_tuning_advisor_task_id str

The SQL tuning task identifier. This is not the OCID.

executionId String

The execution ID for an execution of a SQL tuning task. This is not the OCID.

managedDatabaseId String

The OCID of the Managed Database.

sqlObjectId String

The SQL object ID for the SQL tuning task. This is not the OCID.

sqlTuningAdvisorTaskId String

The SQL tuning task identifier. This is not the OCID.

getManagedDatabaseSqlTuningAdvisorTasksRecommendation Result

The following output properties are available:

ExecutionId string
Id string

The provider-assigned unique ID for this managed resource.

Items List<GetManagedDatabaseSqlTuningAdvisorTasksRecommendationItem>

A list of SQL Tuning Advisor recommendations.

ManagedDatabaseId string
SqlObjectId string
SqlTuningAdvisorTaskId string

The unique identifier of the task. This is not the OCID.

ExecutionId string
Id string

The provider-assigned unique ID for this managed resource.

Items []GetManagedDatabaseSqlTuningAdvisorTasksRecommendationItem

A list of SQL Tuning Advisor recommendations.

ManagedDatabaseId string
SqlObjectId string
SqlTuningAdvisorTaskId string

The unique identifier of the task. This is not the OCID.

executionId String
id String

The provider-assigned unique ID for this managed resource.

items List<GetManagedDatabaseSqlTuningAdvisorTasksRecommendationItem>

A list of SQL Tuning Advisor recommendations.

managedDatabaseId String
sqlObjectId String
sqlTuningAdvisorTaskId String

The unique identifier of the task. This is not the OCID.

executionId string
id string

The provider-assigned unique ID for this managed resource.

items GetManagedDatabaseSqlTuningAdvisorTasksRecommendationItem[]

A list of SQL Tuning Advisor recommendations.

managedDatabaseId string
sqlObjectId string
sqlTuningAdvisorTaskId string

The unique identifier of the task. This is not the OCID.

execution_id str
id str

The provider-assigned unique ID for this managed resource.

items GetManagedDatabaseSqlTuningAdvisorTasksRecommendationItem]

A list of SQL Tuning Advisor recommendations.

managed_database_id str
sql_object_id str
sql_tuning_advisor_task_id str

The unique identifier of the task. This is not the OCID.

executionId String
id String

The provider-assigned unique ID for this managed resource.

items List<Property Map>

A list of SQL Tuning Advisor recommendations.

managedDatabaseId String
sqlObjectId String
sqlTuningAdvisorTaskId String

The unique identifier of the task. This is not the OCID.

Supporting Types

GetManagedDatabaseSqlTuningAdvisorTasksRecommendationItem

Benefit double

The percentage benefit of this implementation.

Finding string

Summary of the issue found in the SQL statement.

ImplementActionSql string

Action sql to be implemented based on the recommendation result.

Rationale string

Describes the reasoning behind the recommendation and how it relates to the finding.

Recommendation string

The recommendation for a specific finding.

RecommendationKey int

The unique identifier of the recommendation in the scope of the task.

RecommendationType string

Type of recommendation.

SqlTuningAdvisorTaskId string

The SQL tuning task identifier. This is not the OCID.

SqlTuningAdvisorTaskObjectId string

The key of the object to which these recommendations apply. This is not the OCID.

Benefit float64

The percentage benefit of this implementation.

Finding string

Summary of the issue found in the SQL statement.

ImplementActionSql string

Action sql to be implemented based on the recommendation result.

Rationale string

Describes the reasoning behind the recommendation and how it relates to the finding.

Recommendation string

The recommendation for a specific finding.

RecommendationKey int

The unique identifier of the recommendation in the scope of the task.

RecommendationType string

Type of recommendation.

SqlTuningAdvisorTaskId string

The SQL tuning task identifier. This is not the OCID.

SqlTuningAdvisorTaskObjectId string

The key of the object to which these recommendations apply. This is not the OCID.

benefit Double

The percentage benefit of this implementation.

finding String

Summary of the issue found in the SQL statement.

implementActionSql String

Action sql to be implemented based on the recommendation result.

rationale String

Describes the reasoning behind the recommendation and how it relates to the finding.

recommendation String

The recommendation for a specific finding.

recommendationKey Integer

The unique identifier of the recommendation in the scope of the task.

recommendationType String

Type of recommendation.

sqlTuningAdvisorTaskId String

The SQL tuning task identifier. This is not the OCID.

sqlTuningAdvisorTaskObjectId String

The key of the object to which these recommendations apply. This is not the OCID.

benefit number

The percentage benefit of this implementation.

finding string

Summary of the issue found in the SQL statement.

implementActionSql string

Action sql to be implemented based on the recommendation result.

rationale string

Describes the reasoning behind the recommendation and how it relates to the finding.

recommendation string

The recommendation for a specific finding.

recommendationKey number

The unique identifier of the recommendation in the scope of the task.

recommendationType string

Type of recommendation.

sqlTuningAdvisorTaskId string

The SQL tuning task identifier. This is not the OCID.

sqlTuningAdvisorTaskObjectId string

The key of the object to which these recommendations apply. This is not the OCID.

benefit float

The percentage benefit of this implementation.

finding str

Summary of the issue found in the SQL statement.

implement_action_sql str

Action sql to be implemented based on the recommendation result.

rationale str

Describes the reasoning behind the recommendation and how it relates to the finding.

recommendation str

The recommendation for a specific finding.

recommendation_key int

The unique identifier of the recommendation in the scope of the task.

recommendation_type str

Type of recommendation.

sql_tuning_advisor_task_id str

The SQL tuning task identifier. 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.

benefit Number

The percentage benefit of this implementation.

finding String

Summary of the issue found in the SQL statement.

implementActionSql String

Action sql to be implemented based on the recommendation result.

rationale String

Describes the reasoning behind the recommendation and how it relates to the finding.

recommendation String

The recommendation for a specific finding.

recommendationKey Number

The unique identifier of the recommendation in the scope of the task.

recommendationType String

Type of recommendation.

sqlTuningAdvisorTaskId String

The SQL tuning task identifier. 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.