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

oci.DatabaseManagement.getManagedDatabaseSqlTuningAdvisorTasksRecommendation

Explore with Pulumi AI

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

    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

    import * as pulumi from "@pulumi/pulumi";
    import * as oci from "@pulumi/oci";
    
    const testManagedDatabaseSqlTuningAdvisorTasksRecommendation = oci.DatabaseManagement.getManagedDatabaseSqlTuningAdvisorTasksRecommendation({
        executionId: testExecution.id,
        managedDatabaseId: testManagedDatabase.id,
        sqlObjectId: testObject.id,
        sqlTuningAdvisorTaskId: testSqlTuningAdvisorTask.id,
    });
    
    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=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"])
    
    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.GetManagedDatabaseSqlTuningAdvisorTasksRecommendation(ctx, &databasemanagement.GetManagedDatabaseSqlTuningAdvisorTasksRecommendationArgs{
    			ExecutionId:            testExecution.Id,
    			ManagedDatabaseId:      testManagedDatabase.Id,
    			SqlObjectId:            testObject.Id,
    			SqlTuningAdvisorTaskId: testSqlTuningAdvisorTask.Id,
    		}, 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 testManagedDatabaseSqlTuningAdvisorTasksRecommendation = Oci.DatabaseManagement.GetManagedDatabaseSqlTuningAdvisorTasksRecommendation.Invoke(new()
        {
            ExecutionId = testExecution.Id,
            ManagedDatabaseId = testManagedDatabase.Id,
            SqlObjectId = testObject.Id,
            SqlTuningAdvisorTaskId = testSqlTuningAdvisorTask.Id,
        });
    
    });
    
    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.GetManagedDatabaseSqlTuningAdvisorTasksRecommendationArgs;
    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 testManagedDatabaseSqlTuningAdvisorTasksRecommendation = DatabaseManagementFunctions.getManagedDatabaseSqlTuningAdvisorTasksRecommendation(GetManagedDatabaseSqlTuningAdvisorTasksRecommendationArgs.builder()
                .executionId(testExecution.id())
                .managedDatabaseId(testManagedDatabase.id())
                .sqlObjectId(testObject.id())
                .sqlTuningAdvisorTaskId(testSqlTuningAdvisorTask.id())
                .build());
    
        }
    }
    
    variables:
      testManagedDatabaseSqlTuningAdvisorTasksRecommendation:
        fn::invoke:
          Function: oci:DatabaseManagement:getManagedDatabaseSqlTuningAdvisorTasksRecommendation
          Arguments:
            executionId: ${testExecution.id}
            managedDatabaseId: ${testManagedDatabase.id}
            sqlObjectId: ${testObject.id}
            sqlTuningAdvisorTaskId: ${testSqlTuningAdvisorTask.id}
    

    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 Sequence[databasemanagement.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.
    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