oci.DatabaseManagement.getManagedDatabaseSqlTuningAdvisorTask (v3)

Oracle Cloud Infrastructure v3.16.0 (3.x), Mar 9 26

Viewing docs for Oracle Cloud Infrastructure v3.16.0 (Older version)
published on Monday, Mar 9, 2026 by Pulumi

Go to latest version

Schema (JSON)

pulumi/pulumi-oci

Viewing docs for Oracle Cloud Infrastructure v3.16.0 (Older version)
published on Monday, Mar 9, 2026 by Pulumi

Go to latest version

Schema (JSON)

pulumi/pulumi-oci

Example Usage

import * as pulumi from "@pulumi/pulumi";
import * as oci from "@pulumi/oci";

const testManagedDatabaseSqlTuningAdvisorTask = oci.DatabaseManagement.getManagedDatabaseSqlTuningAdvisorTask({
    managedDatabaseId: testManagedDatabase.id,
    name: managedDatabaseSqlTuningAdvisorTaskName,
    status: managedDatabaseSqlTuningAdvisorTaskStatus,
    timeGreaterThanOrEqualTo: managedDatabaseSqlTuningAdvisorTaskTimeGreaterThanOrEqualTo,
    timeLessThanOrEqualTo: managedDatabaseSqlTuningAdvisorTaskTimeLessThanOrEqualTo,
});

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=test_managed_database["id"],
    name=managed_database_sql_tuning_advisor_task_name,
    status=managed_database_sql_tuning_advisor_task_status,
    time_greater_than_or_equal_to=managed_database_sql_tuning_advisor_task_time_greater_than_or_equal_to,
    time_less_than_or_equal_to=managed_database_sql_tuning_advisor_task_time_less_than_or_equal_to)

package main

import (
	"github.com/pulumi/pulumi-oci/sdk/v3/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:        testManagedDatabase.Id,
			Name:                     pulumi.StringRef(managedDatabaseSqlTuningAdvisorTaskName),
			Status:                   pulumi.StringRef(managedDatabaseSqlTuningAdvisorTaskStatus),
			TimeGreaterThanOrEqualTo: pulumi.StringRef(managedDatabaseSqlTuningAdvisorTaskTimeGreaterThanOrEqualTo),
			TimeLessThanOrEqualTo:    pulumi.StringRef(managedDatabaseSqlTuningAdvisorTaskTimeLessThanOrEqualTo),
		}, 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 = testManagedDatabase.Id,
        Name = managedDatabaseSqlTuningAdvisorTaskName,
        Status = managedDatabaseSqlTuningAdvisorTaskStatus,
        TimeGreaterThanOrEqualTo = managedDatabaseSqlTuningAdvisorTaskTimeGreaterThanOrEqualTo,
        TimeLessThanOrEqualTo = managedDatabaseSqlTuningAdvisorTaskTimeLessThanOrEqualTo,
    });

});

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(testManagedDatabase.id())
            .name(managedDatabaseSqlTuningAdvisorTaskName)
            .status(managedDatabaseSqlTuningAdvisorTaskStatus)
            .timeGreaterThanOrEqualTo(managedDatabaseSqlTuningAdvisorTaskTimeGreaterThanOrEqualTo)
            .timeLessThanOrEqualTo(managedDatabaseSqlTuningAdvisorTaskTimeLessThanOrEqualTo)
            .build());

    }
}

variables:
  testManagedDatabaseSqlTuningAdvisorTask:
    fn::invoke:
      function: oci:DatabaseManagement:getManagedDatabaseSqlTuningAdvisorTask
      arguments:
        managedDatabaseId: ${testManagedDatabase.id}
        name: ${managedDatabaseSqlTuningAdvisorTaskName}
        status: ${managedDatabaseSqlTuningAdvisorTaskStatus}
        timeGreaterThanOrEqualTo: ${managedDatabaseSqlTuningAdvisorTaskTimeGreaterThanOrEqualTo}
        timeLessThanOrEqualTo: ${managedDatabaseSqlTuningAdvisorTaskTimeLessThanOrEqualTo}

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)
public static Output<GetManagedDatabaseSqlTuningAdvisorTaskResult> getManagedDatabaseSqlTuningAdvisorTask(GetManagedDatabaseSqlTuningAdvisorTaskArgs args, InvokeOptions options)

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