Oracle Cloud Infrastructure

Pulumi Official
Package maintained by Pulumi
v0.1.1 published on Tuesday, May 3, 2022 by Pulumi

getManagedDatabaseSqlTuningAdvisorTasks

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

using Pulumi;
using Oci = Pulumi.Oci;

class MyStack : Stack
{
    public MyStack()
    {
        var testManagedDatabaseSqlTuningAdvisorTasks = Output.Create(Oci.DatabaseManagement.GetManagedDatabaseSqlTuningAdvisorTasks.InvokeAsync(new Oci.DatabaseManagement.GetManagedDatabaseSqlTuningAdvisorTasksArgs
        {
            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 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),
			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
	})
}

Coming soon!

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"],
    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"])
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,
    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,
});

Coming soon!

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,
                                                  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,
                                                  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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

status string
timeGreaterThanOrEqualTo string
timeLessThanOrEqualTo string
id str

The provider-assigned unique ID for this managed resource.

managed_database_id str
sql_tuning_advisor_task_collections GetManagedDatabaseSqlTuningAdvisorTasksSqlTuningAdvisorTaskCollection]

The list of sql_tuning_advisor_task_collection.

filters GetManagedDatabaseSqlTuningAdvisorTasksFilter]
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.

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.

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
https://github.com/pulumi/pulumi-oci
License
Apache-2.0
Notes

This Pulumi package is based on the oci Terraform Provider.