Oracle Cloud Infrastructure

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

getManagedDatabaseSqlTuningAdvisorTask

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

using Pulumi;
using Oci = Pulumi.Oci;

class MyStack : Stack
{
    public MyStack()
    {
        var testManagedDatabaseSqlTuningAdvisorTask = Output.Create(Oci.DatabaseManagement.GetManagedDatabaseSqlTuningAdvisorTask.InvokeAsync(new Oci.DatabaseManagement.GetManagedDatabaseSqlTuningAdvisorTaskArgs
        {
            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.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
	})
}

Coming soon!

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

Coming soon!

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

This Pulumi package is based on the oci Terraform Provider.