1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. DatabaseManagement
  5. getManagedDatabaseSqlTuningAdvisorTasks
Oracle Cloud Infrastructure v1.27.0 published on Friday, Mar 15, 2024 by Pulumi

oci.DatabaseManagement.getManagedDatabaseSqlTuningAdvisorTasks

Explore with Pulumi AI

oci logo
Oracle Cloud Infrastructure v1.27.0 published on Friday, Mar 15, 2024 by Pulumi

    This data source provides the list of Managed Database Sql Tuning Advisor Tasks 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 testManagedDatabaseSqlTuningAdvisorTasks = oci.DatabaseManagement.getManagedDatabaseSqlTuningAdvisorTasks({
        managedDatabaseId: oci_database_management_managed_database.test_managed_database.id,
        name: _var.managed_database_sql_tuning_advisor_task_name,
        opcNamedCredentialId: _var.managed_database_sql_tuning_advisor_task_opc_named_credential_id,
        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_tasks = oci.DatabaseManagement.get_managed_database_sql_tuning_advisor_tasks(managed_database_id=oci_database_management_managed_database["test_managed_database"]["id"],
        name=var["managed_database_sql_tuning_advisor_task_name"],
        opc_named_credential_id=var["managed_database_sql_tuning_advisor_task_opc_named_credential_id"],
        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.GetManagedDatabaseSqlTuningAdvisorTasks(ctx, &databasemanagement.GetManagedDatabaseSqlTuningAdvisorTasksArgs{
    			ManagedDatabaseId:        oci_database_management_managed_database.Test_managed_database.Id,
    			Name:                     pulumi.StringRef(_var.Managed_database_sql_tuning_advisor_task_name),
    			OpcNamedCredentialId:     pulumi.StringRef(_var.Managed_database_sql_tuning_advisor_task_opc_named_credential_id),
    			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 testManagedDatabaseSqlTuningAdvisorTasks = Oci.DatabaseManagement.GetManagedDatabaseSqlTuningAdvisorTasks.Invoke(new()
        {
            ManagedDatabaseId = oci_database_management_managed_database.Test_managed_database.Id,
            Name = @var.Managed_database_sql_tuning_advisor_task_name,
            OpcNamedCredentialId = @var.Managed_database_sql_tuning_advisor_task_opc_named_credential_id,
            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.GetManagedDatabaseSqlTuningAdvisorTasksArgs;
    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 testManagedDatabaseSqlTuningAdvisorTasks = DatabaseManagementFunctions.getManagedDatabaseSqlTuningAdvisorTasks(GetManagedDatabaseSqlTuningAdvisorTasksArgs.builder()
                .managedDatabaseId(oci_database_management_managed_database.test_managed_database().id())
                .name(var_.managed_database_sql_tuning_advisor_task_name())
                .opcNamedCredentialId(var_.managed_database_sql_tuning_advisor_task_opc_named_credential_id())
                .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:
      testManagedDatabaseSqlTuningAdvisorTasks:
        fn::invoke:
          Function: oci:DatabaseManagement:getManagedDatabaseSqlTuningAdvisorTasks
          Arguments:
            managedDatabaseId: ${oci_database_management_managed_database.test_managed_database.id}
            name: ${var.managed_database_sql_tuning_advisor_task_name}
            opcNamedCredentialId: ${var.managed_database_sql_tuning_advisor_task_opc_named_credential_id}
            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 getManagedDatabaseSqlTuningAdvisorTasks

    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 getManagedDatabaseSqlTuningAdvisorTasks(args: GetManagedDatabaseSqlTuningAdvisorTasksArgs, opts?: InvokeOptions): Promise<GetManagedDatabaseSqlTuningAdvisorTasksResult>
    function getManagedDatabaseSqlTuningAdvisorTasksOutput(args: GetManagedDatabaseSqlTuningAdvisorTasksOutputArgs, opts?: InvokeOptions): Output<GetManagedDatabaseSqlTuningAdvisorTasksResult>
    def get_managed_database_sql_tuning_advisor_tasks(filters: Optional[Sequence[_databasemanagement.GetManagedDatabaseSqlTuningAdvisorTasksFilter]] = None,
                                                      managed_database_id: Optional[str] = None,
                                                      name: Optional[str] = None,
                                                      opc_named_credential_id: 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) -> GetManagedDatabaseSqlTuningAdvisorTasksResult
    def get_managed_database_sql_tuning_advisor_tasks_output(filters: Optional[pulumi.Input[Sequence[pulumi.Input[_databasemanagement.GetManagedDatabaseSqlTuningAdvisorTasksFilterArgs]]]] = None,
                                                      managed_database_id: Optional[pulumi.Input[str]] = None,
                                                      name: Optional[pulumi.Input[str]] = None,
                                                      opc_named_credential_id: 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[GetManagedDatabaseSqlTuningAdvisorTasksResult]
    func GetManagedDatabaseSqlTuningAdvisorTasks(ctx *Context, args *GetManagedDatabaseSqlTuningAdvisorTasksArgs, opts ...InvokeOption) (*GetManagedDatabaseSqlTuningAdvisorTasksResult, error)
    func GetManagedDatabaseSqlTuningAdvisorTasksOutput(ctx *Context, args *GetManagedDatabaseSqlTuningAdvisorTasksOutputArgs, opts ...InvokeOption) GetManagedDatabaseSqlTuningAdvisorTasksResultOutput

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

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

    The following arguments are supported:

    ManagedDatabaseId string
    The OCID of the Managed Database.
    Filters List<GetManagedDatabaseSqlTuningAdvisorTasksFilter>
    Name string
    The optional query parameter to filter the SQL Tuning Advisor task list by name.
    OpcNamedCredentialId string
    The OCID of the Named Credential.
    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.
    Filters []GetManagedDatabaseSqlTuningAdvisorTasksFilter
    Name string
    The optional query parameter to filter the SQL Tuning Advisor task list by name.
    OpcNamedCredentialId string
    The OCID of the Named Credential.
    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.
    filters List<GetManagedDatabaseSqlTuningAdvisorTasksFilter>
    name String
    The optional query parameter to filter the SQL Tuning Advisor task list by name.
    opcNamedCredentialId String
    The OCID of the Named Credential.
    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.
    filters GetManagedDatabaseSqlTuningAdvisorTasksFilter[]
    name string
    The optional query parameter to filter the SQL Tuning Advisor task list by name.
    opcNamedCredentialId string
    The OCID of the Named Credential.
    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.
    filters GetManagedDatabaseSqlTuningAdvisorTasksFilter]
    name str
    The optional query parameter to filter the SQL Tuning Advisor task list by name.
    opc_named_credential_id str
    The OCID of the Named Credential.
    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.
    filters List<Property Map>
    name String
    The optional query parameter to filter the SQL Tuning Advisor task list by name.
    opcNamedCredentialId String
    The OCID of the Named Credential.
    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.

    getManagedDatabaseSqlTuningAdvisorTasks Result

    The following output properties are available:

    Id string
    The provider-assigned unique ID for this managed resource.
    ManagedDatabaseId string
    SqlTuningAdvisorTaskCollections List<GetManagedDatabaseSqlTuningAdvisorTasksSqlTuningAdvisorTaskCollection>
    The list of sql_tuning_advisor_task_collection.
    Filters List<GetManagedDatabaseSqlTuningAdvisorTasksFilter>
    Name string
    The name of the SQL Tuning Advisor task.
    OpcNamedCredentialId string
    Status string
    TimeGreaterThanOrEqualTo string
    TimeLessThanOrEqualTo string
    Id string
    The provider-assigned unique ID for this managed resource.
    ManagedDatabaseId string
    SqlTuningAdvisorTaskCollections []GetManagedDatabaseSqlTuningAdvisorTasksSqlTuningAdvisorTaskCollection
    The list of sql_tuning_advisor_task_collection.
    Filters []GetManagedDatabaseSqlTuningAdvisorTasksFilter
    Name string
    The name of the SQL Tuning Advisor task.
    OpcNamedCredentialId string
    Status string
    TimeGreaterThanOrEqualTo string
    TimeLessThanOrEqualTo string
    id String
    The provider-assigned unique ID for this managed resource.
    managedDatabaseId String
    sqlTuningAdvisorTaskCollections List<GetManagedDatabaseSqlTuningAdvisorTasksSqlTuningAdvisorTaskCollection>
    The list of sql_tuning_advisor_task_collection.
    filters List<GetManagedDatabaseSqlTuningAdvisorTasksFilter>
    name String
    The name of the SQL Tuning Advisor task.
    opcNamedCredentialId String
    status String
    timeGreaterThanOrEqualTo String
    timeLessThanOrEqualTo String
    id string
    The provider-assigned unique ID for this managed resource.
    managedDatabaseId string
    sqlTuningAdvisorTaskCollections GetManagedDatabaseSqlTuningAdvisorTasksSqlTuningAdvisorTaskCollection[]
    The list of sql_tuning_advisor_task_collection.
    filters GetManagedDatabaseSqlTuningAdvisorTasksFilter[]
    name string
    The name of the SQL Tuning Advisor task.
    opcNamedCredentialId string
    status string
    timeGreaterThanOrEqualTo string
    timeLessThanOrEqualTo string
    id String
    The provider-assigned unique ID for this managed resource.
    managedDatabaseId String
    sqlTuningAdvisorTaskCollections List<Property Map>
    The list of sql_tuning_advisor_task_collection.
    filters List<Property Map>
    name String
    The name of the SQL Tuning Advisor task.
    opcNamedCredentialId String
    status String
    timeGreaterThanOrEqualTo String
    timeLessThanOrEqualTo String

    Supporting Types

    GetManagedDatabaseSqlTuningAdvisorTasksFilter

    Name string
    The optional query parameter to filter the SQL Tuning Advisor task list by name.
    Values List<string>
    Regex bool
    Name string
    The optional query parameter to filter the SQL Tuning Advisor task list by name.
    Values []string
    Regex bool
    name String
    The optional query parameter to filter the SQL Tuning Advisor task list by name.
    values List<String>
    regex Boolean
    name string
    The optional query parameter to filter the SQL Tuning Advisor task list by name.
    values string[]
    regex boolean
    name str
    The optional query parameter to filter the SQL Tuning Advisor task list by name.
    values Sequence[str]
    regex bool
    name String
    The optional query parameter to filter the SQL Tuning Advisor task list by name.
    values List<String>
    regex Boolean

    GetManagedDatabaseSqlTuningAdvisorTasksSqlTuningAdvisorTaskCollection

    items List<Property Map>
    A list of SQL Tuning Advisor tasks.

    GetManagedDatabaseSqlTuningAdvisorTasksSqlTuningAdvisorTaskCollectionItem

    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.27.0 published on Friday, Mar 15, 2024 by Pulumi