Oracle Cloud Infrastructure

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

getManagedDatabaseSqlTuningAdvisorTasksRecommendations

This data source provides the list of Managed Database Sql Tuning Advisor Tasks Recommendations 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 testManagedDatabaseSqlTuningAdvisorTasksRecommendations = Output.Create(Oci.DatabaseManagement.GetManagedDatabaseSqlTuningAdvisorTasksRecommendations.InvokeAsync(new Oci.DatabaseManagement.GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsArgs
        {
            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.GetManagedDatabaseSqlTuningAdvisorTasksRecommendations(ctx, &databasemanagement.GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsArgs{
			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_recommendations = oci.DatabaseManagement.get_managed_database_sql_tuning_advisor_tasks_recommendations(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 testManagedDatabaseSqlTuningAdvisorTasksRecommendations = oci.DatabaseManagement.getManagedDatabaseSqlTuningAdvisorTasksRecommendations({
    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 getManagedDatabaseSqlTuningAdvisorTasksRecommendations

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 getManagedDatabaseSqlTuningAdvisorTasksRecommendations(args: GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsArgs, opts?: InvokeOptions): Promise<GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsResult>
function getManagedDatabaseSqlTuningAdvisorTasksRecommendationsOutput(args: GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsOutputArgs, opts?: InvokeOptions): Output<GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsResult>
def get_managed_database_sql_tuning_advisor_tasks_recommendations(execution_id: Optional[str] = None,
                                                                  filters: Optional[Sequence[_databasemanagement.GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsFilter]] = 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) -> GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsResult
def get_managed_database_sql_tuning_advisor_tasks_recommendations_output(execution_id: Optional[pulumi.Input[str]] = None,
                                                                  filters: Optional[pulumi.Input[Sequence[pulumi.Input[_databasemanagement.GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsFilterArgs]]]] = 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[GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsResult]
func GetManagedDatabaseSqlTuningAdvisorTasksRecommendations(ctx *Context, args *GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsArgs, opts ...InvokeOption) (*GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsResult, error)
func GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsOutput(ctx *Context, args *GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsOutputArgs, opts ...InvokeOption) GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsResultOutput

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

public static class GetManagedDatabaseSqlTuningAdvisorTasksRecommendations 
{
    public static Task<GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsResult> InvokeAsync(GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsArgs args, InvokeOptions? opts = null)
    public static Output<GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsResult> Invoke(GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsInvokeArgs args, InvokeOptions? opts = null)
}
public static CompletableFuture<GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsResult> getManagedDatabaseSqlTuningAdvisorTasksRecommendations(GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsArgs args, InvokeOptions options)
// Output-based functions aren't available in Java yet
Fn::Invoke:
  Function: oci:DatabaseManagement/getManagedDatabaseSqlTuningAdvisorTasksRecommendations:getManagedDatabaseSqlTuningAdvisorTasksRecommendations
  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.

Filters List<GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsFilter>
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.

Filters []GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsFilter
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.

filters List<GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsFilter>
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.

filters GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsFilter[]
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.

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

filters List<Property Map>

getManagedDatabaseSqlTuningAdvisorTasksRecommendations Result

The following output properties are available:

ExecutionId string
Id string

The provider-assigned unique ID for this managed resource.

ManagedDatabaseId string
SqlObjectId string
SqlTuningAdvisorTaskId string

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

SqlTuningAdvisorTaskRecommendationCollections List<GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsSqlTuningAdvisorTaskRecommendationCollection>

The list of sql_tuning_advisor_task_recommendation_collection.

Filters List<GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsFilter>
ExecutionId string
Id string

The provider-assigned unique ID for this managed resource.

ManagedDatabaseId string
SqlObjectId string
SqlTuningAdvisorTaskId string

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

SqlTuningAdvisorTaskRecommendationCollections []GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsSqlTuningAdvisorTaskRecommendationCollection

The list of sql_tuning_advisor_task_recommendation_collection.

Filters []GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsFilter
executionId String
id String

The provider-assigned unique ID for this managed resource.

managedDatabaseId String
sqlObjectId String
sqlTuningAdvisorTaskId String

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

sqlTuningAdvisorTaskRecommendationCollections List<GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsSqlTuningAdvisorTaskRecommendationCollection>

The list of sql_tuning_advisor_task_recommendation_collection.

filters List<GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsFilter>
executionId string
id string

The provider-assigned unique ID for this managed resource.

managedDatabaseId string
sqlObjectId string
sqlTuningAdvisorTaskId string

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

sqlTuningAdvisorTaskRecommendationCollections GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsSqlTuningAdvisorTaskRecommendationCollection[]

The list of sql_tuning_advisor_task_recommendation_collection.

filters GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsFilter[]
executionId String
id String

The provider-assigned unique ID for this managed resource.

managedDatabaseId String
sqlObjectId String
sqlTuningAdvisorTaskId String

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

sqlTuningAdvisorTaskRecommendationCollections List<Property Map>

The list of sql_tuning_advisor_task_recommendation_collection.

filters List<Property Map>

Supporting Types

GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsFilter

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

GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsSqlTuningAdvisorTaskRecommendationCollection

items List<Property Map>

A list of SQL Tuning Advisor recommendations.

GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsSqlTuningAdvisorTaskRecommendationCollectionItem

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.