Oracle Cloud Infrastructure v2.18.0 published on Friday, Nov 22, 2024 by Pulumi
oci.DatabaseManagement.getManagedDatabaseSqlTuningAdvisorTasks
Explore with Pulumi AI
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: testManagedDatabase.id,
name: managedDatabaseSqlTuningAdvisorTaskName,
opcNamedCredentialId: managedDatabaseSqlTuningAdvisorTaskOpcNamedCredentialId,
status: managedDatabaseSqlTuningAdvisorTaskStatus,
timeGreaterThanOrEqualTo: managedDatabaseSqlTuningAdvisorTaskTimeGreaterThanOrEqualTo,
timeLessThanOrEqualTo: managedDatabaseSqlTuningAdvisorTaskTimeLessThanOrEqualTo,
});
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=test_managed_database["id"],
name=managed_database_sql_tuning_advisor_task_name,
opc_named_credential_id=managed_database_sql_tuning_advisor_task_opc_named_credential_id,
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/v2/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: testManagedDatabase.Id,
Name: pulumi.StringRef(managedDatabaseSqlTuningAdvisorTaskName),
OpcNamedCredentialId: pulumi.StringRef(managedDatabaseSqlTuningAdvisorTaskOpcNamedCredentialId),
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 testManagedDatabaseSqlTuningAdvisorTasks = Oci.DatabaseManagement.GetManagedDatabaseSqlTuningAdvisorTasks.Invoke(new()
{
ManagedDatabaseId = testManagedDatabase.Id,
Name = managedDatabaseSqlTuningAdvisorTaskName,
OpcNamedCredentialId = managedDatabaseSqlTuningAdvisorTaskOpcNamedCredentialId,
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.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(testManagedDatabase.id())
.name(managedDatabaseSqlTuningAdvisorTaskName)
.opcNamedCredentialId(managedDatabaseSqlTuningAdvisorTaskOpcNamedCredentialId)
.status(managedDatabaseSqlTuningAdvisorTaskStatus)
.timeGreaterThanOrEqualTo(managedDatabaseSqlTuningAdvisorTaskTimeGreaterThanOrEqualTo)
.timeLessThanOrEqualTo(managedDatabaseSqlTuningAdvisorTaskTimeLessThanOrEqualTo)
.build());
}
}
variables:
testManagedDatabaseSqlTuningAdvisorTasks:
fn::invoke:
Function: oci:DatabaseManagement:getManagedDatabaseSqlTuningAdvisorTasks
Arguments:
managedDatabaseId: ${testManagedDatabase.id}
name: ${managedDatabaseSqlTuningAdvisorTaskName}
opcNamedCredentialId: ${managedDatabaseSqlTuningAdvisorTaskOpcNamedCredentialId}
status: ${managedDatabaseSqlTuningAdvisorTaskStatus}
timeGreaterThanOrEqualTo: ${managedDatabaseSqlTuningAdvisorTaskTimeGreaterThanOrEqualTo}
timeLessThanOrEqualTo: ${managedDatabaseSqlTuningAdvisorTaskTimeLessThanOrEqualTo}
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:
- Managed
Database stringId - The OCID of the Managed Database.
- Filters
List<Get
Managed Database Sql Tuning Advisor Tasks Filter> - Name string
- The optional query parameter to filter the SQL Tuning Advisor task list by name.
- Opc
Named stringCredential Id - The OCID of the Named Credential.
- Status string
- The optional query parameter to filter the SQL Tuning Advisor task list by status.
- Time
Greater stringThan Or Equal To - The optional greater than or equal to query parameter to filter the timestamp.
- Time
Less stringThan Or Equal To - The optional less than or equal to query parameter to filter the timestamp.
- Managed
Database stringId - The OCID of the Managed Database.
- Filters
[]Get
Managed Database Sql Tuning Advisor Tasks Filter - Name string
- The optional query parameter to filter the SQL Tuning Advisor task list by name.
- Opc
Named stringCredential Id - The OCID of the Named Credential.
- Status string
- The optional query parameter to filter the SQL Tuning Advisor task list by status.
- Time
Greater stringThan Or Equal To - The optional greater than or equal to query parameter to filter the timestamp.
- Time
Less stringThan Or Equal To - The optional less than or equal to query parameter to filter the timestamp.
- managed
Database StringId - The OCID of the Managed Database.
- filters
List<Get
Managed Database Sql Tuning Advisor Tasks Filter> - name String
- The optional query parameter to filter the SQL Tuning Advisor task list by name.
- opc
Named StringCredential Id - The OCID of the Named Credential.
- status String
- The optional query parameter to filter the SQL Tuning Advisor task list by status.
- time
Greater StringThan Or Equal To - The optional greater than or equal to query parameter to filter the timestamp.
- time
Less StringThan Or Equal To - The optional less than or equal to query parameter to filter the timestamp.
- managed
Database stringId - The OCID of the Managed Database.
- filters
Get
Managed Database Sql Tuning Advisor Tasks Filter[] - name string
- The optional query parameter to filter the SQL Tuning Advisor task list by name.
- opc
Named stringCredential Id - The OCID of the Named Credential.
- status string
- The optional query parameter to filter the SQL Tuning Advisor task list by status.
- time
Greater stringThan Or Equal To - The optional greater than or equal to query parameter to filter the timestamp.
- time
Less stringThan Or Equal To - The optional less than or equal to query parameter to filter the timestamp.
- managed_
database_ strid - The OCID of the Managed Database.
- filters
Sequence[databasemanagement.
Get Managed Database Sql Tuning Advisor Tasks Filter] - name str
- The optional query parameter to filter the SQL Tuning Advisor task list by name.
- opc_
named_ strcredential_ id - The OCID of the Named Credential.
- status str
- The optional query parameter to filter the SQL Tuning Advisor task list by status.
- time_
greater_ strthan_ or_ equal_ to - The optional greater than or equal to query parameter to filter the timestamp.
- time_
less_ strthan_ or_ equal_ to - The optional less than or equal to query parameter to filter the timestamp.
- managed
Database StringId - 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.
- opc
Named StringCredential Id - The OCID of the Named Credential.
- status String
- The optional query parameter to filter the SQL Tuning Advisor task list by status.
- time
Greater StringThan Or Equal To - The optional greater than or equal to query parameter to filter the timestamp.
- time
Less StringThan Or Equal To - 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.
- Managed
Database stringId - Sql
Tuning List<GetAdvisor Task Collections Managed Database Sql Tuning Advisor Tasks Sql Tuning Advisor Task Collection> - The list of sql_tuning_advisor_task_collection.
- Filters
List<Get
Managed Database Sql Tuning Advisor Tasks Filter> - Name string
- The name of the SQL Tuning Advisor task.
- Opc
Named stringCredential Id - Status string
- Time
Greater stringThan Or Equal To - Time
Less stringThan Or Equal To
- Id string
- The provider-assigned unique ID for this managed resource.
- Managed
Database stringId - Sql
Tuning []GetAdvisor Task Collections Managed Database Sql Tuning Advisor Tasks Sql Tuning Advisor Task Collection - The list of sql_tuning_advisor_task_collection.
- Filters
[]Get
Managed Database Sql Tuning Advisor Tasks Filter - Name string
- The name of the SQL Tuning Advisor task.
- Opc
Named stringCredential Id - Status string
- Time
Greater stringThan Or Equal To - Time
Less stringThan Or Equal To
- id String
- The provider-assigned unique ID for this managed resource.
- managed
Database StringId - sql
Tuning List<GetAdvisor Task Collections Managed Database Sql Tuning Advisor Tasks Sql Tuning Advisor Task Collection> - The list of sql_tuning_advisor_task_collection.
- filters
List<Get
Managed Database Sql Tuning Advisor Tasks Filter> - name String
- The name of the SQL Tuning Advisor task.
- opc
Named StringCredential Id - status String
- time
Greater StringThan Or Equal To - time
Less StringThan Or Equal To
- id string
- The provider-assigned unique ID for this managed resource.
- managed
Database stringId - sql
Tuning GetAdvisor Task Collections Managed Database Sql Tuning Advisor Tasks Sql Tuning Advisor Task Collection[] - The list of sql_tuning_advisor_task_collection.
- filters
Get
Managed Database Sql Tuning Advisor Tasks Filter[] - name string
- The name of the SQL Tuning Advisor task.
- opc
Named stringCredential Id - status string
- time
Greater stringThan Or Equal To - time
Less stringThan Or Equal To
- id str
- The provider-assigned unique ID for this managed resource.
- managed_
database_ strid - sql_
tuning_ Sequence[databasemanagement.advisor_ task_ collections Get Managed Database Sql Tuning Advisor Tasks Sql Tuning Advisor Task Collection] - The list of sql_tuning_advisor_task_collection.
- filters
Sequence[databasemanagement.
Get Managed Database Sql Tuning Advisor Tasks Filter] - name str
- The name of the SQL Tuning Advisor task.
- opc_
named_ strcredential_ id - status str
- time_
greater_ strthan_ or_ equal_ to - time_
less_ strthan_ or_ equal_ to
- id String
- The provider-assigned unique ID for this managed resource.
- managed
Database StringId - sql
Tuning List<Property Map>Advisor Task Collections - The list of sql_tuning_advisor_task_collection.
- filters List<Property Map>
- name String
- The name of the SQL Tuning Advisor task.
- opc
Named StringCredential Id - status String
- time
Greater StringThan Or Equal To - time
Less StringThan Or Equal To
Supporting Types
GetManagedDatabaseSqlTuningAdvisorTasksFilter
GetManagedDatabaseSqlTuningAdvisorTasksSqlTuningAdvisorTaskCollection
- Items
List<Get
Managed Database Sql Tuning Advisor Tasks Sql Tuning Advisor Task Collection Item> - A list of SQL Tuning Advisor tasks.
- Items
[]Get
Managed Database Sql Tuning Advisor Tasks Sql Tuning Advisor Task Collection Item - A list of SQL Tuning Advisor tasks.
- items
List<Get
Managed Database Sql Tuning Advisor Tasks Sql Tuning Advisor Task Collection Item> - A list of SQL Tuning Advisor tasks.
- items
Get
Managed Database Sql Tuning Advisor Tasks Sql Tuning Advisor Task Collection Item[] - A list of SQL Tuning Advisor tasks.
- items
Sequence[databasemanagement.
Get Managed Database Sql Tuning Advisor Tasks Sql Tuning Advisor Task Collection Item] - A list of SQL Tuning Advisor tasks.
- items List<Property Map>
- A list of SQL Tuning Advisor tasks.
GetManagedDatabaseSqlTuningAdvisorTasksSqlTuningAdvisorTaskCollectionItem
- Days
To intExpire - 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.
- Instance
Id 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.
- Recommendation
Count int - The number of recommendations provided for the SQL Tuning Advisor task.
- Sql
Tuning stringAdvisor Task Id - The unique identifier of the SQL Tuning Advisor task. This is not the OCID.
- Task
Status string - The status of the SQL Tuning Advisor task.
- Time
Created string - The Creation date of the SQL Tuning Advisor task.
- Time
Execution stringEnded - The end time of the task execution.
- Time
Execution stringStarted - The start time of the task execution.
- Total
Sql intStatements - The total number of SQL statements related to the SQL Tuning Advisor task.
- Days
To intExpire - 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.
- Instance
Id 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.
- Recommendation
Count int - The number of recommendations provided for the SQL Tuning Advisor task.
- Sql
Tuning stringAdvisor Task Id - The unique identifier of the SQL Tuning Advisor task. This is not the OCID.
- Task
Status string - The status of the SQL Tuning Advisor task.
- Time
Created string - The Creation date of the SQL Tuning Advisor task.
- Time
Execution stringEnded - The end time of the task execution.
- Time
Execution stringStarted - The start time of the task execution.
- Total
Sql intStatements - The total number of SQL statements related to the SQL Tuning Advisor task.
- days
To IntegerExpire - 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.
- instance
Id 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.
- recommendation
Count Integer - The number of recommendations provided for the SQL Tuning Advisor task.
- sql
Tuning StringAdvisor Task Id - The unique identifier of the SQL Tuning Advisor task. This is not the OCID.
- task
Status String - The status of the SQL Tuning Advisor task.
- time
Created String - The Creation date of the SQL Tuning Advisor task.
- time
Execution StringEnded - The end time of the task execution.
- time
Execution StringStarted - The start time of the task execution.
- total
Sql IntegerStatements - The total number of SQL statements related to the SQL Tuning Advisor task.
- days
To numberExpire - 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.
- instance
Id 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.
- recommendation
Count number - The number of recommendations provided for the SQL Tuning Advisor task.
- sql
Tuning stringAdvisor Task Id - The unique identifier of the SQL Tuning Advisor task. This is not the OCID.
- task
Status string - The status of the SQL Tuning Advisor task.
- time
Created string - The Creation date of the SQL Tuning Advisor task.
- time
Execution stringEnded - The end time of the task execution.
- time
Execution stringStarted - The start time of the task execution.
- total
Sql numberStatements - The total number of SQL statements related to the SQL Tuning Advisor task.
- days_
to_ intexpire - 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_ stradvisor_ task_ id - 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_ strended - The end time of the task execution.
- time_
execution_ strstarted - The start time of the task execution.
- total_
sql_ intstatements - The total number of SQL statements related to the SQL Tuning Advisor task.
- days
To NumberExpire - 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.
- instance
Id 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.
- recommendation
Count Number - The number of recommendations provided for the SQL Tuning Advisor task.
- sql
Tuning StringAdvisor Task Id - The unique identifier of the SQL Tuning Advisor task. This is not the OCID.
- task
Status String - The status of the SQL Tuning Advisor task.
- time
Created String - The Creation date of the SQL Tuning Advisor task.
- time
Execution StringEnded - The end time of the task execution.
- time
Execution StringStarted - The start time of the task execution.
- total
Sql NumberStatements - 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.