Oracle Cloud Infrastructure v3.0.0, Jun 5 25

Oracle Cloud Infrastructure v3.0.0 published on Thursday, Jun 5, 2025 by Pulumi

oci.DatabaseManagement.getManagedDatabaseSqlTuningAdvisorTasksRecommendations

Explore with Pulumi AI

Oracle Cloud Infrastructure v3.0.0 published on Thursday, Jun 5, 2025 by Pulumi

Example Usage

import * as pulumi from "@pulumi/pulumi";
import * as oci from "@pulumi/oci";

const testManagedDatabaseSqlTuningAdvisorTasksRecommendations = oci.DatabaseManagement.getManagedDatabaseSqlTuningAdvisorTasksRecommendations({
    executionId: testExecution.id,
    managedDatabaseId: testManagedDatabase.id,
    sqlObjectId: testObject.id,
    sqlTuningAdvisorTaskId: testSqlTuningAdvisorTask.id,
    opcNamedCredentialId: managedDatabaseSqlTuningAdvisorTasksRecommendationOpcNamedCredentialId,
});

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=test_execution["id"],
    managed_database_id=test_managed_database["id"],
    sql_object_id=test_object["id"],
    sql_tuning_advisor_task_id=test_sql_tuning_advisor_task["id"],
    opc_named_credential_id=managed_database_sql_tuning_advisor_tasks_recommendation_opc_named_credential_id)

package main

import (
	"github.com/pulumi/pulumi-oci/sdk/v3/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:            testExecution.Id,
			ManagedDatabaseId:      testManagedDatabase.Id,
			SqlObjectId:            testObject.Id,
			SqlTuningAdvisorTaskId: testSqlTuningAdvisorTask.Id,
			OpcNamedCredentialId:   pulumi.StringRef(managedDatabaseSqlTuningAdvisorTasksRecommendationOpcNamedCredentialId),
		}, 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 testManagedDatabaseSqlTuningAdvisorTasksRecommendations = Oci.DatabaseManagement.GetManagedDatabaseSqlTuningAdvisorTasksRecommendations.Invoke(new()
    {
        ExecutionId = testExecution.Id,
        ManagedDatabaseId = testManagedDatabase.Id,
        SqlObjectId = testObject.Id,
        SqlTuningAdvisorTaskId = testSqlTuningAdvisorTask.Id,
        OpcNamedCredentialId = managedDatabaseSqlTuningAdvisorTasksRecommendationOpcNamedCredentialId,
    });

});

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.GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsArgs;
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 testManagedDatabaseSqlTuningAdvisorTasksRecommendations = DatabaseManagementFunctions.getManagedDatabaseSqlTuningAdvisorTasksRecommendations(GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsArgs.builder()
            .executionId(testExecution.id())
            .managedDatabaseId(testManagedDatabase.id())
            .sqlObjectId(testObject.id())
            .sqlTuningAdvisorTaskId(testSqlTuningAdvisorTask.id())
            .opcNamedCredentialId(managedDatabaseSqlTuningAdvisorTasksRecommendationOpcNamedCredentialId)
            .build());

    }
}

variables:
  testManagedDatabaseSqlTuningAdvisorTasksRecommendations:
    fn::invoke:
      function: oci:DatabaseManagement:getManagedDatabaseSqlTuningAdvisorTasksRecommendations
      arguments:
        executionId: ${testExecution.id}
        managedDatabaseId: ${testManagedDatabase.id}
        sqlObjectId: ${testObject.id}
        sqlTuningAdvisorTaskId: ${testSqlTuningAdvisorTask.id}
        opcNamedCredentialId: ${managedDatabaseSqlTuningAdvisorTasksRecommendationOpcNamedCredentialId}

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[GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsFilter]] = None,
                                                                  managed_database_id: Optional[str] = None,
                                                                  opc_named_credential_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[GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsFilterArgs]]]] = None,
                                                                  managed_database_id: Optional[pulumi.Input[str]] = None,
                                                                  opc_named_credential_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)
public static Output<GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsResult> getManagedDatabaseSqlTuningAdvisorTasksRecommendations(GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsArgs args, InvokeOptions options)

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>
OpcNamedCredentialId string: The OCID of the Named Credential.

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
OpcNamedCredentialId string: The OCID of the Named Credential.

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>
opcNamedCredentialId String: The OCID of the Named Credential.

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[]
opcNamedCredentialId string: The OCID of the Named Credential.

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 Sequence[GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsFilter]
opc_named_credential_id str: The OCID of the Named Credential.

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>
opcNamedCredentialId String: The OCID of the Named Credential.

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>
OpcNamedCredentialId string

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
OpcNamedCredentialId string

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>
opcNamedCredentialId String

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[]
opcNamedCredentialId string

execution_id str
id str: The provider-assigned unique ID for this managed resource.
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.
sql_tuning_advisor_task_recommendation_collections Sequence[GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsSqlTuningAdvisorTaskRecommendationCollection]: The list of sql_tuning_advisor_task_recommendation_collection.
filters Sequence[GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsFilter]
opc_named_credential_id str

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>
opcNamedCredentialId String

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<GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsSqlTuningAdvisorTaskRecommendationCollectionItem>: A list of SQL Tuning Advisor recommendations.

Items []GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsSqlTuningAdvisorTaskRecommendationCollectionItem: A list of SQL Tuning Advisor recommendations.

items List<GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsSqlTuningAdvisorTaskRecommendationCollectionItem>: A list of SQL Tuning Advisor recommendations.

items GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsSqlTuningAdvisorTaskRecommendationCollectionItem[]: A list of SQL Tuning Advisor recommendations.

items Sequence[GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsSqlTuningAdvisorTaskRecommendationCollectionItem]: A list of SQL Tuning Advisor recommendations.

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.
IsParallelExecution bool: Indicates whether a SQL Profile recommendation uses parallel execution.
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.
IsParallelExecution bool: Indicates whether a SQL Profile recommendation uses parallel execution.
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.
isParallelExecution Boolean: Indicates whether a SQL Profile recommendation uses parallel execution.
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.
isParallelExecution boolean: Indicates whether a SQL Profile recommendation uses parallel execution.
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.
is_parallel_execution bool: Indicates whether a SQL Profile recommendation uses parallel execution.
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.
isParallelExecution Boolean: Indicates whether a SQL Profile recommendation uses parallel execution.
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: oci pulumi/pulumi-oci
License: Apache-2.0
Notes: This Pulumi package is based on the oci Terraform Provider.

Oracle Cloud Infrastructure v3.0.0 published on Thursday, Jun 5, 2025 by Pulumi

pulumi/pulumi-oci

oci.DatabaseManagement.getManagedDatabaseSqlTuningAdvisorTasksRecommendations

On this page

On this page

Example Usage

Using getManagedDatabaseSqlTuningAdvisorTasksRecommendations

getManagedDatabaseSqlTuningAdvisorTasksRecommendations Result

Supporting Types

GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsFilter

GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsSqlTuningAdvisorTaskRecommendationCollection

GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsSqlTuningAdvisorTaskRecommendationCollectionItem

Package Details

On this page

On this page