oci.DatabaseManagement.getManagedDatabaseSqlTuningSets
Explore with Pulumi AI
This data source provides the list of Managed Database Sql Tuning Sets in Oracle Cloud Infrastructure Database Management service.
Lists the SQL tuning sets for the specified Managed Database.
Example Usage
using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Oci = Pulumi.Oci;
return await Deployment.RunAsync(() =>
{
var testManagedDatabaseSqlTuningSets = Oci.DatabaseManagement.GetManagedDatabaseSqlTuningSets.Invoke(new()
{
ManagedDatabaseId = oci_database_management_managed_database.Test_managed_database.Id,
NameContains = @var.Managed_database_sql_tuning_set_name_contains,
Owner = @var.Managed_database_sql_tuning_set_owner,
});
});
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.GetManagedDatabaseSqlTuningSets(ctx, &databasemanagement.GetManagedDatabaseSqlTuningSetsArgs{
ManagedDatabaseId: oci_database_management_managed_database.Test_managed_database.Id,
NameContains: pulumi.StringRef(_var.Managed_database_sql_tuning_set_name_contains),
Owner: pulumi.StringRef(_var.Managed_database_sql_tuning_set_owner),
}, nil)
if err != nil {
return err
}
return nil
})
}
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.GetManagedDatabaseSqlTuningSetsArgs;
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 testManagedDatabaseSqlTuningSets = DatabaseManagementFunctions.getManagedDatabaseSqlTuningSets(GetManagedDatabaseSqlTuningSetsArgs.builder()
.managedDatabaseId(oci_database_management_managed_database.test_managed_database().id())
.nameContains(var_.managed_database_sql_tuning_set_name_contains())
.owner(var_.managed_database_sql_tuning_set_owner())
.build());
}
}
import pulumi
import pulumi_oci as oci
test_managed_database_sql_tuning_sets = oci.DatabaseManagement.get_managed_database_sql_tuning_sets(managed_database_id=oci_database_management_managed_database["test_managed_database"]["id"],
name_contains=var["managed_database_sql_tuning_set_name_contains"],
owner=var["managed_database_sql_tuning_set_owner"])
import * as pulumi from "@pulumi/pulumi";
import * as oci from "@pulumi/oci";
const testManagedDatabaseSqlTuningSets = oci.DatabaseManagement.getManagedDatabaseSqlTuningSets({
managedDatabaseId: oci_database_management_managed_database.test_managed_database.id,
nameContains: _var.managed_database_sql_tuning_set_name_contains,
owner: _var.managed_database_sql_tuning_set_owner,
});
variables:
testManagedDatabaseSqlTuningSets:
fn::invoke:
Function: oci:DatabaseManagement:getManagedDatabaseSqlTuningSets
Arguments:
managedDatabaseId: ${oci_database_management_managed_database.test_managed_database.id}
nameContains: ${var.managed_database_sql_tuning_set_name_contains}
owner: ${var.managed_database_sql_tuning_set_owner}
Using getManagedDatabaseSqlTuningSets
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 getManagedDatabaseSqlTuningSets(args: GetManagedDatabaseSqlTuningSetsArgs, opts?: InvokeOptions): Promise<GetManagedDatabaseSqlTuningSetsResult>
function getManagedDatabaseSqlTuningSetsOutput(args: GetManagedDatabaseSqlTuningSetsOutputArgs, opts?: InvokeOptions): Output<GetManagedDatabaseSqlTuningSetsResult>
def get_managed_database_sql_tuning_sets(filters: Optional[Sequence[_databasemanagement.GetManagedDatabaseSqlTuningSetsFilter]] = None,
managed_database_id: Optional[str] = None,
name_contains: Optional[str] = None,
owner: Optional[str] = None,
opts: Optional[InvokeOptions] = None) -> GetManagedDatabaseSqlTuningSetsResult
def get_managed_database_sql_tuning_sets_output(filters: Optional[pulumi.Input[Sequence[pulumi.Input[_databasemanagement.GetManagedDatabaseSqlTuningSetsFilterArgs]]]] = None,
managed_database_id: Optional[pulumi.Input[str]] = None,
name_contains: Optional[pulumi.Input[str]] = None,
owner: Optional[pulumi.Input[str]] = None,
opts: Optional[InvokeOptions] = None) -> Output[GetManagedDatabaseSqlTuningSetsResult]
func GetManagedDatabaseSqlTuningSets(ctx *Context, args *GetManagedDatabaseSqlTuningSetsArgs, opts ...InvokeOption) (*GetManagedDatabaseSqlTuningSetsResult, error)
func GetManagedDatabaseSqlTuningSetsOutput(ctx *Context, args *GetManagedDatabaseSqlTuningSetsOutputArgs, opts ...InvokeOption) GetManagedDatabaseSqlTuningSetsResultOutput
> Note: This function is named GetManagedDatabaseSqlTuningSets
in the Go SDK.
public static class GetManagedDatabaseSqlTuningSets
{
public static Task<GetManagedDatabaseSqlTuningSetsResult> InvokeAsync(GetManagedDatabaseSqlTuningSetsArgs args, InvokeOptions? opts = null)
public static Output<GetManagedDatabaseSqlTuningSetsResult> Invoke(GetManagedDatabaseSqlTuningSetsInvokeArgs args, InvokeOptions? opts = null)
}
public static CompletableFuture<GetManagedDatabaseSqlTuningSetsResult> getManagedDatabaseSqlTuningSets(GetManagedDatabaseSqlTuningSetsArgs args, InvokeOptions options)
// Output-based functions aren't available in Java yet
fn::invoke:
function: oci:DatabaseManagement/getManagedDatabaseSqlTuningSets:getManagedDatabaseSqlTuningSets
arguments:
# arguments dictionary
The following arguments are supported:
- Managed
Database stringId The OCID of the Managed Database.
- Filters
List<Get
Managed Database Sql Tuning Sets Filter> - Name
Contains string Allow searching the name of the SQL tuning set by partial matching. The search is case insensitive.
- Owner string
The owner of the SQL tuning set.
- Managed
Database stringId The OCID of the Managed Database.
- Filters
[]Get
Managed Database Sql Tuning Sets Filter - Name
Contains string Allow searching the name of the SQL tuning set by partial matching. The search is case insensitive.
- Owner string
The owner of the SQL tuning set.
- managed
Database StringId The OCID of the Managed Database.
- filters
List<Get
Managed Database Sql Tuning Sets Filter> - name
Contains String Allow searching the name of the SQL tuning set by partial matching. The search is case insensitive.
- owner String
The owner of the SQL tuning set.
- managed
Database stringId The OCID of the Managed Database.
- filters
Get
Managed Database Sql Tuning Sets Filter[] - name
Contains string Allow searching the name of the SQL tuning set by partial matching. The search is case insensitive.
- owner string
The owner of the SQL tuning set.
- managed_
database_ strid The OCID of the Managed Database.
- filters
Get
Managed Database Sql Tuning Sets Filter] - name_
contains str Allow searching the name of the SQL tuning set by partial matching. The search is case insensitive.
- owner str
The owner of the SQL tuning set.
- managed
Database StringId The OCID of the Managed Database.
- filters List<Property Map>
- name
Contains String Allow searching the name of the SQL tuning set by partial matching. The search is case insensitive.
- owner String
The owner of the SQL tuning set.
getManagedDatabaseSqlTuningSets Result
The following output properties are available:
- Id string
The provider-assigned unique ID for this managed resource.
- Managed
Database stringId The OCID of the Managed Database.
- Sql
Tuning List<GetSet Collections Managed Database Sql Tuning Sets Sql Tuning Set Collection> The list of sql_tuning_set_collection.
- Filters
List<Get
Managed Database Sql Tuning Sets Filter> - Name
Contains string - Owner string
The owner of the SQL tuning set.
- Id string
The provider-assigned unique ID for this managed resource.
- Managed
Database stringId The OCID of the Managed Database.
- Sql
Tuning []GetSet Collections Managed Database Sql Tuning Sets Sql Tuning Set Collection The list of sql_tuning_set_collection.
- Filters
[]Get
Managed Database Sql Tuning Sets Filter - Name
Contains string - Owner string
The owner of the SQL tuning set.
- id String
The provider-assigned unique ID for this managed resource.
- managed
Database StringId The OCID of the Managed Database.
- sql
Tuning List<GetSet Collections Managed Database Sql Tuning Sets Sql Tuning Set Collection> The list of sql_tuning_set_collection.
- filters
List<Get
Managed Database Sql Tuning Sets Filter> - name
Contains String - owner String
The owner of the SQL tuning set.
- id string
The provider-assigned unique ID for this managed resource.
- managed
Database stringId The OCID of the Managed Database.
- sql
Tuning GetSet Collections Managed Database Sql Tuning Sets Sql Tuning Set Collection[] The list of sql_tuning_set_collection.
- filters
Get
Managed Database Sql Tuning Sets Filter[] - name
Contains string - owner string
The owner of the SQL tuning set.
- id str
The provider-assigned unique ID for this managed resource.
- managed_
database_ strid The OCID of the Managed Database.
- sql_
tuning_ Getset_ collections Managed Database Sql Tuning Sets Sql Tuning Set Collection] The list of sql_tuning_set_collection.
- filters
Get
Managed Database Sql Tuning Sets Filter] - name_
contains str - owner str
The owner of the SQL tuning set.
- id String
The provider-assigned unique ID for this managed resource.
- managed
Database StringId The OCID of the Managed Database.
- sql
Tuning List<Property Map>Set Collections The list of sql_tuning_set_collection.
- filters List<Property Map>
- name
Contains String - owner String
The owner of the SQL tuning set.
Supporting Types
GetManagedDatabaseSqlTuningSetsFilter
GetManagedDatabaseSqlTuningSetsSqlTuningSetCollection
- Items
List<Get
Managed Database Sql Tuning Sets Sql Tuning Set Collection Item> The details in the SQL tuning set summary.
- Items
[]Get
Managed Database Sql Tuning Sets Sql Tuning Set Collection Item The details in the SQL tuning set summary.
- items
List<Get
Managed Database Sql Tuning Sets Sql Tuning Set Collection Item> The details in the SQL tuning set summary.
- items
Get
Managed Database Sql Tuning Sets Sql Tuning Set Collection Item[] The details in the SQL tuning set summary.
- items
Get
Managed Database Sql Tuning Sets Sql Tuning Set Collection Item] The details in the SQL tuning set summary.
- items List<Property Map>
The details in the SQL tuning set summary.
GetManagedDatabaseSqlTuningSetsSqlTuningSetCollectionItem
- Description string
The description of the SQL tuning set.
- Error
Message string Latest execution error of the plsql that was submitted as a scheduler job.
- Id int
The unique Sql tuning set identifier. This is not OCID.
- Name string
The name of the SQL tuning set.
- Owner string
The owner of the SQL tuning set.
- Scheduled
Job stringName Name of the Sql tuning set scheduler job.
- Statement
Counts int The number of SQL statements in the SQL tuning set.
- Status string
Current status of the Sql tuning set.
- Time
Created string The created time of the Sql tuning set.
- Time
Last stringModified Last modified time of the Sql tuning set.
- Description string
The description of the SQL tuning set.
- Error
Message string Latest execution error of the plsql that was submitted as a scheduler job.
- Id int
The unique Sql tuning set identifier. This is not OCID.
- Name string
The name of the SQL tuning set.
- Owner string
The owner of the SQL tuning set.
- Scheduled
Job stringName Name of the Sql tuning set scheduler job.
- Statement
Counts int The number of SQL statements in the SQL tuning set.
- Status string
Current status of the Sql tuning set.
- Time
Created string The created time of the Sql tuning set.
- Time
Last stringModified Last modified time of the Sql tuning set.
- description String
The description of the SQL tuning set.
- error
Message String Latest execution error of the plsql that was submitted as a scheduler job.
- id Integer
The unique Sql tuning set identifier. This is not OCID.
- name String
The name of the SQL tuning set.
- owner String
The owner of the SQL tuning set.
- scheduled
Job StringName Name of the Sql tuning set scheduler job.
- statement
Counts Integer The number of SQL statements in the SQL tuning set.
- status String
Current status of the Sql tuning set.
- time
Created String The created time of the Sql tuning set.
- time
Last StringModified Last modified time of the Sql tuning set.
- description string
The description of the SQL tuning set.
- error
Message string Latest execution error of the plsql that was submitted as a scheduler job.
- id number
The unique Sql tuning set identifier. This is not OCID.
- name string
The name of the SQL tuning set.
- owner string
The owner of the SQL tuning set.
- scheduled
Job stringName Name of the Sql tuning set scheduler job.
- statement
Counts number The number of SQL statements in the SQL tuning set.
- status string
Current status of the Sql tuning set.
- time
Created string The created time of the Sql tuning set.
- time
Last stringModified Last modified time of the Sql tuning set.
- description str
The description of the SQL tuning set.
- error_
message str Latest execution error of the plsql that was submitted as a scheduler job.
- id int
The unique Sql tuning set identifier. This is not OCID.
- name str
The name of the SQL tuning set.
- owner str
The owner of the SQL tuning set.
- scheduled_
job_ strname Name of the Sql tuning set scheduler job.
- statement_
counts int The number of SQL statements in the SQL tuning set.
- status str
Current status of the Sql tuning set.
- time_
created str The created time of the Sql tuning set.
- time_
last_ strmodified Last modified time of the Sql tuning set.
- description String
The description of the SQL tuning set.
- error
Message String Latest execution error of the plsql that was submitted as a scheduler job.
- id Number
The unique Sql tuning set identifier. This is not OCID.
- name String
The name of the SQL tuning set.
- owner String
The owner of the SQL tuning set.
- scheduled
Job StringName Name of the Sql tuning set scheduler job.
- statement
Counts Number The number of SQL statements in the SQL tuning set.
- status String
Current status of the Sql tuning set.
- time
Created String The created time of the Sql tuning set.
- time
Last StringModified Last modified time of the Sql tuning set.
Package Details
- Repository
- oci pulumi/pulumi-oci
- License
- Apache-2.0
- Notes
This Pulumi package is based on the
oci
Terraform Provider.