1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. DatabaseManagement
  5. getManagedDatabaseSqlTuningAdvisorTasksRecommendations
Oracle Cloud Infrastructure v2.3.0 published on Wednesday, Jul 17, 2024 by Pulumi

oci.DatabaseManagement.getManagedDatabaseSqlTuningAdvisorTasksRecommendations

Explore with Pulumi AI

oci logo
Oracle Cloud Infrastructure v2.3.0 published on Wednesday, Jul 17, 2024 by Pulumi

    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

    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/v2/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[_databasemanagement.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[_databasemanagement.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)
    // 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>
    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[databasemanagement.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
    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<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.
    oci logo
    Oracle Cloud Infrastructure v2.3.0 published on Wednesday, Jul 17, 2024 by Pulumi