1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. DatabaseManagement
  5. getManagedDatabaseSqlTuningAdvisorTask
Oracle Cloud Infrastructure v1.29.0 published on Thursday, Mar 28, 2024 by Pulumi

oci.DatabaseManagement.getManagedDatabaseSqlTuningAdvisorTask

Explore with Pulumi AI

oci logo
Oracle Cloud Infrastructure v1.29.0 published on Thursday, Mar 28, 2024 by Pulumi

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

    Lists the SQL Tuning Advisor tasks for the specified Managed Database.

    Example Usage

    import * as pulumi from "@pulumi/pulumi";
    import * as oci from "@pulumi/oci";
    
    const testManagedDatabaseSqlTuningAdvisorTask = oci.DatabaseManagement.getManagedDatabaseSqlTuningAdvisorTask({
        managedDatabaseId: oci_database_management_managed_database.test_managed_database.id,
        name: _var.managed_database_sql_tuning_advisor_task_name,
        status: _var.managed_database_sql_tuning_advisor_task_status,
        timeGreaterThanOrEqualTo: _var.managed_database_sql_tuning_advisor_task_time_greater_than_or_equal_to,
        timeLessThanOrEqualTo: _var.managed_database_sql_tuning_advisor_task_time_less_than_or_equal_to,
    });
    
    import pulumi
    import pulumi_oci as oci
    
    test_managed_database_sql_tuning_advisor_task = oci.DatabaseManagement.get_managed_database_sql_tuning_advisor_task(managed_database_id=oci_database_management_managed_database["test_managed_database"]["id"],
        name=var["managed_database_sql_tuning_advisor_task_name"],
        status=var["managed_database_sql_tuning_advisor_task_status"],
        time_greater_than_or_equal_to=var["managed_database_sql_tuning_advisor_task_time_greater_than_or_equal_to"],
        time_less_than_or_equal_to=var["managed_database_sql_tuning_advisor_task_time_less_than_or_equal_to"])
    
    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.GetManagedDatabaseSqlTuningAdvisorTask(ctx, &databasemanagement.GetManagedDatabaseSqlTuningAdvisorTaskArgs{
    			ManagedDatabaseId:        oci_database_management_managed_database.Test_managed_database.Id,
    			Name:                     pulumi.StringRef(_var.Managed_database_sql_tuning_advisor_task_name),
    			Status:                   pulumi.StringRef(_var.Managed_database_sql_tuning_advisor_task_status),
    			TimeGreaterThanOrEqualTo: pulumi.StringRef(_var.Managed_database_sql_tuning_advisor_task_time_greater_than_or_equal_to),
    			TimeLessThanOrEqualTo:    pulumi.StringRef(_var.Managed_database_sql_tuning_advisor_task_time_less_than_or_equal_to),
    		}, 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 testManagedDatabaseSqlTuningAdvisorTask = Oci.DatabaseManagement.GetManagedDatabaseSqlTuningAdvisorTask.Invoke(new()
        {
            ManagedDatabaseId = oci_database_management_managed_database.Test_managed_database.Id,
            Name = @var.Managed_database_sql_tuning_advisor_task_name,
            Status = @var.Managed_database_sql_tuning_advisor_task_status,
            TimeGreaterThanOrEqualTo = @var.Managed_database_sql_tuning_advisor_task_time_greater_than_or_equal_to,
            TimeLessThanOrEqualTo = @var.Managed_database_sql_tuning_advisor_task_time_less_than_or_equal_to,
        });
    
    });
    
    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.GetManagedDatabaseSqlTuningAdvisorTaskArgs;
    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 testManagedDatabaseSqlTuningAdvisorTask = DatabaseManagementFunctions.getManagedDatabaseSqlTuningAdvisorTask(GetManagedDatabaseSqlTuningAdvisorTaskArgs.builder()
                .managedDatabaseId(oci_database_management_managed_database.test_managed_database().id())
                .name(var_.managed_database_sql_tuning_advisor_task_name())
                .status(var_.managed_database_sql_tuning_advisor_task_status())
                .timeGreaterThanOrEqualTo(var_.managed_database_sql_tuning_advisor_task_time_greater_than_or_equal_to())
                .timeLessThanOrEqualTo(var_.managed_database_sql_tuning_advisor_task_time_less_than_or_equal_to())
                .build());
    
        }
    }
    
    variables:
      testManagedDatabaseSqlTuningAdvisorTask:
        fn::invoke:
          Function: oci:DatabaseManagement:getManagedDatabaseSqlTuningAdvisorTask
          Arguments:
            managedDatabaseId: ${oci_database_management_managed_database.test_managed_database.id}
            name: ${var.managed_database_sql_tuning_advisor_task_name}
            status: ${var.managed_database_sql_tuning_advisor_task_status}
            timeGreaterThanOrEqualTo: ${var.managed_database_sql_tuning_advisor_task_time_greater_than_or_equal_to}
            timeLessThanOrEqualTo: ${var.managed_database_sql_tuning_advisor_task_time_less_than_or_equal_to}
    

    Using getManagedDatabaseSqlTuningAdvisorTask

    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 getManagedDatabaseSqlTuningAdvisorTask(args: GetManagedDatabaseSqlTuningAdvisorTaskArgs, opts?: InvokeOptions): Promise<GetManagedDatabaseSqlTuningAdvisorTaskResult>
    function getManagedDatabaseSqlTuningAdvisorTaskOutput(args: GetManagedDatabaseSqlTuningAdvisorTaskOutputArgs, opts?: InvokeOptions): Output<GetManagedDatabaseSqlTuningAdvisorTaskResult>
    def get_managed_database_sql_tuning_advisor_task(managed_database_id: Optional[str] = None,
                                                     name: Optional[str] = None,
                                                     status: Optional[str] = None,
                                                     time_greater_than_or_equal_to: Optional[str] = None,
                                                     time_less_than_or_equal_to: Optional[str] = None,
                                                     opts: Optional[InvokeOptions] = None) -> GetManagedDatabaseSqlTuningAdvisorTaskResult
    def get_managed_database_sql_tuning_advisor_task_output(managed_database_id: Optional[pulumi.Input[str]] = None,
                                                     name: Optional[pulumi.Input[str]] = None,
                                                     status: Optional[pulumi.Input[str]] = None,
                                                     time_greater_than_or_equal_to: Optional[pulumi.Input[str]] = None,
                                                     time_less_than_or_equal_to: Optional[pulumi.Input[str]] = None,
                                                     opts: Optional[InvokeOptions] = None) -> Output[GetManagedDatabaseSqlTuningAdvisorTaskResult]
    func GetManagedDatabaseSqlTuningAdvisorTask(ctx *Context, args *GetManagedDatabaseSqlTuningAdvisorTaskArgs, opts ...InvokeOption) (*GetManagedDatabaseSqlTuningAdvisorTaskResult, error)
    func GetManagedDatabaseSqlTuningAdvisorTaskOutput(ctx *Context, args *GetManagedDatabaseSqlTuningAdvisorTaskOutputArgs, opts ...InvokeOption) GetManagedDatabaseSqlTuningAdvisorTaskResultOutput

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

    public static class GetManagedDatabaseSqlTuningAdvisorTask 
    {
        public static Task<GetManagedDatabaseSqlTuningAdvisorTaskResult> InvokeAsync(GetManagedDatabaseSqlTuningAdvisorTaskArgs args, InvokeOptions? opts = null)
        public static Output<GetManagedDatabaseSqlTuningAdvisorTaskResult> Invoke(GetManagedDatabaseSqlTuningAdvisorTaskInvokeArgs args, InvokeOptions? opts = null)
    }
    public static CompletableFuture<GetManagedDatabaseSqlTuningAdvisorTaskResult> getManagedDatabaseSqlTuningAdvisorTask(GetManagedDatabaseSqlTuningAdvisorTaskArgs args, InvokeOptions options)
    // Output-based functions aren't available in Java yet
    
    fn::invoke:
      function: oci:DatabaseManagement/getManagedDatabaseSqlTuningAdvisorTask:getManagedDatabaseSqlTuningAdvisorTask
      arguments:
        # arguments dictionary

    The following arguments are supported:

    ManagedDatabaseId string
    The OCID of the Managed Database.
    Name string
    The optional query parameter to filter the SQL Tuning Advisor task list by name.
    Status string
    The optional query parameter to filter the SQL Tuning Advisor task list by status.
    TimeGreaterThanOrEqualTo string
    The optional greater than or equal to query parameter to filter the timestamp.
    TimeLessThanOrEqualTo string
    The optional less than or equal to query parameter to filter the timestamp.
    ManagedDatabaseId string
    The OCID of the Managed Database.
    Name string
    The optional query parameter to filter the SQL Tuning Advisor task list by name.
    Status string
    The optional query parameter to filter the SQL Tuning Advisor task list by status.
    TimeGreaterThanOrEqualTo string
    The optional greater than or equal to query parameter to filter the timestamp.
    TimeLessThanOrEqualTo string
    The optional less than or equal to query parameter to filter the timestamp.
    managedDatabaseId String
    The OCID of the Managed Database.
    name String
    The optional query parameter to filter the SQL Tuning Advisor task list by name.
    status String
    The optional query parameter to filter the SQL Tuning Advisor task list by status.
    timeGreaterThanOrEqualTo String
    The optional greater than or equal to query parameter to filter the timestamp.
    timeLessThanOrEqualTo String
    The optional less than or equal to query parameter to filter the timestamp.
    managedDatabaseId string
    The OCID of the Managed Database.
    name string
    The optional query parameter to filter the SQL Tuning Advisor task list by name.
    status string
    The optional query parameter to filter the SQL Tuning Advisor task list by status.
    timeGreaterThanOrEqualTo string
    The optional greater than or equal to query parameter to filter the timestamp.
    timeLessThanOrEqualTo string
    The optional less than or equal to query parameter to filter the timestamp.
    managed_database_id str
    The OCID of the Managed Database.
    name str
    The optional query parameter to filter the SQL Tuning Advisor task list by name.
    status str
    The optional query parameter to filter the SQL Tuning Advisor task list by status.
    time_greater_than_or_equal_to str
    The optional greater than or equal to query parameter to filter the timestamp.
    time_less_than_or_equal_to str
    The optional less than or equal to query parameter to filter the timestamp.
    managedDatabaseId String
    The OCID of the Managed Database.
    name String
    The optional query parameter to filter the SQL Tuning Advisor task list by name.
    status String
    The optional query parameter to filter the SQL Tuning Advisor task list by status.
    timeGreaterThanOrEqualTo String
    The optional greater than or equal to query parameter to filter the timestamp.
    timeLessThanOrEqualTo String
    The optional less than or equal to query parameter to filter the timestamp.

    getManagedDatabaseSqlTuningAdvisorTask Result

    The following output properties are available:

    Id string
    The provider-assigned unique ID for this managed resource.
    Items List<GetManagedDatabaseSqlTuningAdvisorTaskItem>
    A list of SQL Tuning Advisor tasks.
    ManagedDatabaseId string
    Name string
    The name of the SQL Tuning Advisor task.
    Status string
    TimeGreaterThanOrEqualTo string
    TimeLessThanOrEqualTo string
    Id string
    The provider-assigned unique ID for this managed resource.
    Items []GetManagedDatabaseSqlTuningAdvisorTaskItem
    A list of SQL Tuning Advisor tasks.
    ManagedDatabaseId string
    Name string
    The name of the SQL Tuning Advisor task.
    Status string
    TimeGreaterThanOrEqualTo string
    TimeLessThanOrEqualTo string
    id String
    The provider-assigned unique ID for this managed resource.
    items List<GetManagedDatabaseSqlTuningAdvisorTaskItem>
    A list of SQL Tuning Advisor tasks.
    managedDatabaseId String
    name String
    The name of the SQL Tuning Advisor task.
    status String
    timeGreaterThanOrEqualTo String
    timeLessThanOrEqualTo String
    id string
    The provider-assigned unique ID for this managed resource.
    items GetManagedDatabaseSqlTuningAdvisorTaskItem[]
    A list of SQL Tuning Advisor tasks.
    managedDatabaseId string
    name string
    The name of the SQL Tuning Advisor task.
    status string
    timeGreaterThanOrEqualTo string
    timeLessThanOrEqualTo string
    id str
    The provider-assigned unique ID for this managed resource.
    items GetManagedDatabaseSqlTuningAdvisorTaskItem]
    A list of SQL Tuning Advisor tasks.
    managed_database_id str
    name str
    The name of the SQL Tuning Advisor task.
    status str
    time_greater_than_or_equal_to str
    time_less_than_or_equal_to str
    id String
    The provider-assigned unique ID for this managed resource.
    items List<Property Map>
    A list of SQL Tuning Advisor tasks.
    managedDatabaseId String
    name String
    The name of the SQL Tuning Advisor task.
    status String
    timeGreaterThanOrEqualTo String
    timeLessThanOrEqualTo String

    Supporting Types

    GetManagedDatabaseSqlTuningAdvisorTaskItem

    DaysToExpire int
    The number of days left before the task expires. If the value equals -1, then the task has no expiration time (UNLIMITED).
    Description string
    The description of the SQL Tuning Advisor task.
    InstanceId int
    The instance ID of the SQL Tuning Advisor task. This is not the OCID.
    Name string
    The optional query parameter to filter the SQL Tuning Advisor task list by name.
    Owner string
    The owner of the SQL Tuning Advisor task.
    RecommendationCount int
    The number of recommendations provided for the SQL Tuning Advisor task.
    SqlTuningAdvisorTaskId string
    The unique identifier of the SQL Tuning Advisor task. This is not the OCID.
    TaskStatus string
    The status of the SQL Tuning Advisor task.
    TimeCreated string
    The Creation date of the SQL Tuning Advisor task.
    TimeExecutionEnded string
    The end time of the task execution.
    TimeExecutionStarted string
    The start time of the task execution.
    TotalSqlStatements int
    The total number of SQL statements related to the SQL Tuning Advisor task.
    DaysToExpire int
    The number of days left before the task expires. If the value equals -1, then the task has no expiration time (UNLIMITED).
    Description string
    The description of the SQL Tuning Advisor task.
    InstanceId int
    The instance ID of the SQL Tuning Advisor task. This is not the OCID.
    Name string
    The optional query parameter to filter the SQL Tuning Advisor task list by name.
    Owner string
    The owner of the SQL Tuning Advisor task.
    RecommendationCount int
    The number of recommendations provided for the SQL Tuning Advisor task.
    SqlTuningAdvisorTaskId string
    The unique identifier of the SQL Tuning Advisor task. This is not the OCID.
    TaskStatus string
    The status of the SQL Tuning Advisor task.
    TimeCreated string
    The Creation date of the SQL Tuning Advisor task.
    TimeExecutionEnded string
    The end time of the task execution.
    TimeExecutionStarted string
    The start time of the task execution.
    TotalSqlStatements int
    The total number of SQL statements related to the SQL Tuning Advisor task.
    daysToExpire Integer
    The number of days left before the task expires. If the value equals -1, then the task has no expiration time (UNLIMITED).
    description String
    The description of the SQL Tuning Advisor task.
    instanceId Integer
    The instance ID of the SQL Tuning Advisor task. This is not the OCID.
    name String
    The optional query parameter to filter the SQL Tuning Advisor task list by name.
    owner String
    The owner of the SQL Tuning Advisor task.
    recommendationCount Integer
    The number of recommendations provided for the SQL Tuning Advisor task.
    sqlTuningAdvisorTaskId String
    The unique identifier of the SQL Tuning Advisor task. This is not the OCID.
    taskStatus String
    The status of the SQL Tuning Advisor task.
    timeCreated String
    The Creation date of the SQL Tuning Advisor task.
    timeExecutionEnded String
    The end time of the task execution.
    timeExecutionStarted String
    The start time of the task execution.
    totalSqlStatements Integer
    The total number of SQL statements related to the SQL Tuning Advisor task.
    daysToExpire number
    The number of days left before the task expires. If the value equals -1, then the task has no expiration time (UNLIMITED).
    description string
    The description of the SQL Tuning Advisor task.
    instanceId number
    The instance ID of the SQL Tuning Advisor task. This is not the OCID.
    name string
    The optional query parameter to filter the SQL Tuning Advisor task list by name.
    owner string
    The owner of the SQL Tuning Advisor task.
    recommendationCount number
    The number of recommendations provided for the SQL Tuning Advisor task.
    sqlTuningAdvisorTaskId string
    The unique identifier of the SQL Tuning Advisor task. This is not the OCID.
    taskStatus string
    The status of the SQL Tuning Advisor task.
    timeCreated string
    The Creation date of the SQL Tuning Advisor task.
    timeExecutionEnded string
    The end time of the task execution.
    timeExecutionStarted string
    The start time of the task execution.
    totalSqlStatements number
    The total number of SQL statements related to the SQL Tuning Advisor task.
    days_to_expire int
    The number of days left before the task expires. If the value equals -1, then the task has no expiration time (UNLIMITED).
    description str
    The description of the SQL Tuning Advisor task.
    instance_id int
    The instance ID of the SQL Tuning Advisor task. This is not the OCID.
    name str
    The optional query parameter to filter the SQL Tuning Advisor task list by name.
    owner str
    The owner of the SQL Tuning Advisor task.
    recommendation_count int
    The number of recommendations provided for the SQL Tuning Advisor task.
    sql_tuning_advisor_task_id str
    The unique identifier of the SQL Tuning Advisor task. This is not the OCID.
    task_status str
    The status of the SQL Tuning Advisor task.
    time_created str
    The Creation date of the SQL Tuning Advisor task.
    time_execution_ended str
    The end time of the task execution.
    time_execution_started str
    The start time of the task execution.
    total_sql_statements int
    The total number of SQL statements related to the SQL Tuning Advisor task.
    daysToExpire Number
    The number of days left before the task expires. If the value equals -1, then the task has no expiration time (UNLIMITED).
    description String
    The description of the SQL Tuning Advisor task.
    instanceId Number
    The instance ID of the SQL Tuning Advisor task. This is not the OCID.
    name String
    The optional query parameter to filter the SQL Tuning Advisor task list by name.
    owner String
    The owner of the SQL Tuning Advisor task.
    recommendationCount Number
    The number of recommendations provided for the SQL Tuning Advisor task.
    sqlTuningAdvisorTaskId String
    The unique identifier of the SQL Tuning Advisor task. This is not the OCID.
    taskStatus String
    The status of the SQL Tuning Advisor task.
    timeCreated String
    The Creation date of the SQL Tuning Advisor task.
    timeExecutionEnded String
    The end time of the task execution.
    timeExecutionStarted String
    The start time of the task execution.
    totalSqlStatements Number
    The total number of SQL statements related to the SQL Tuning Advisor task.

    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 v1.29.0 published on Thursday, Mar 28, 2024 by Pulumi