Oracle Cloud Infrastructure v2.19.0 published on Thursday, Dec 12, 2024 by Pulumi
oci.DatabaseManagement.getManagedDatabaseCursorCacheStatements
Explore with Pulumi AI
This data source provides the list of Managed Database Cursor Cache Statements in Oracle Cloud Infrastructure Database Management service.
Lists the SQL statements from shared SQL area, also called the cursor cache.
Example Usage
import * as pulumi from "@pulumi/pulumi";
import * as oci from "@pulumi/oci";
const testManagedDatabaseCursorCacheStatements = oci.DatabaseManagement.getManagedDatabaseCursorCacheStatements({
managedDatabaseId: testManagedDatabase.id,
opcNamedCredentialId: managedDatabaseCursorCacheStatementOpcNamedCredentialId,
sqlText: managedDatabaseCursorCacheStatementSqlText,
});
import pulumi
import pulumi_oci as oci
test_managed_database_cursor_cache_statements = oci.DatabaseManagement.get_managed_database_cursor_cache_statements(managed_database_id=test_managed_database["id"],
opc_named_credential_id=managed_database_cursor_cache_statement_opc_named_credential_id,
sql_text=managed_database_cursor_cache_statement_sql_text)
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.GetManagedDatabaseCursorCacheStatements(ctx, &databasemanagement.GetManagedDatabaseCursorCacheStatementsArgs{
ManagedDatabaseId: testManagedDatabase.Id,
OpcNamedCredentialId: pulumi.StringRef(managedDatabaseCursorCacheStatementOpcNamedCredentialId),
SqlText: pulumi.StringRef(managedDatabaseCursorCacheStatementSqlText),
}, 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 testManagedDatabaseCursorCacheStatements = Oci.DatabaseManagement.GetManagedDatabaseCursorCacheStatements.Invoke(new()
{
ManagedDatabaseId = testManagedDatabase.Id,
OpcNamedCredentialId = managedDatabaseCursorCacheStatementOpcNamedCredentialId,
SqlText = managedDatabaseCursorCacheStatementSqlText,
});
});
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.GetManagedDatabaseCursorCacheStatementsArgs;
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 testManagedDatabaseCursorCacheStatements = DatabaseManagementFunctions.getManagedDatabaseCursorCacheStatements(GetManagedDatabaseCursorCacheStatementsArgs.builder()
.managedDatabaseId(testManagedDatabase.id())
.opcNamedCredentialId(managedDatabaseCursorCacheStatementOpcNamedCredentialId)
.sqlText(managedDatabaseCursorCacheStatementSqlText)
.build());
}
}
variables:
testManagedDatabaseCursorCacheStatements:
fn::invoke:
function: oci:DatabaseManagement:getManagedDatabaseCursorCacheStatements
arguments:
managedDatabaseId: ${testManagedDatabase.id}
opcNamedCredentialId: ${managedDatabaseCursorCacheStatementOpcNamedCredentialId}
sqlText: ${managedDatabaseCursorCacheStatementSqlText}
Using getManagedDatabaseCursorCacheStatements
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 getManagedDatabaseCursorCacheStatements(args: GetManagedDatabaseCursorCacheStatementsArgs, opts?: InvokeOptions): Promise<GetManagedDatabaseCursorCacheStatementsResult>
function getManagedDatabaseCursorCacheStatementsOutput(args: GetManagedDatabaseCursorCacheStatementsOutputArgs, opts?: InvokeOptions): Output<GetManagedDatabaseCursorCacheStatementsResult>
def get_managed_database_cursor_cache_statements(filters: Optional[Sequence[_databasemanagement.GetManagedDatabaseCursorCacheStatementsFilter]] = None,
limit: Optional[int] = None,
managed_database_id: Optional[str] = None,
opc_named_credential_id: Optional[str] = None,
sql_text: Optional[str] = None,
opts: Optional[InvokeOptions] = None) -> GetManagedDatabaseCursorCacheStatementsResult
def get_managed_database_cursor_cache_statements_output(filters: Optional[pulumi.Input[Sequence[pulumi.Input[_databasemanagement.GetManagedDatabaseCursorCacheStatementsFilterArgs]]]] = None,
limit: Optional[pulumi.Input[int]] = None,
managed_database_id: Optional[pulumi.Input[str]] = None,
opc_named_credential_id: Optional[pulumi.Input[str]] = None,
sql_text: Optional[pulumi.Input[str]] = None,
opts: Optional[InvokeOptions] = None) -> Output[GetManagedDatabaseCursorCacheStatementsResult]
func GetManagedDatabaseCursorCacheStatements(ctx *Context, args *GetManagedDatabaseCursorCacheStatementsArgs, opts ...InvokeOption) (*GetManagedDatabaseCursorCacheStatementsResult, error)
func GetManagedDatabaseCursorCacheStatementsOutput(ctx *Context, args *GetManagedDatabaseCursorCacheStatementsOutputArgs, opts ...InvokeOption) GetManagedDatabaseCursorCacheStatementsResultOutput
> Note: This function is named GetManagedDatabaseCursorCacheStatements
in the Go SDK.
public static class GetManagedDatabaseCursorCacheStatements
{
public static Task<GetManagedDatabaseCursorCacheStatementsResult> InvokeAsync(GetManagedDatabaseCursorCacheStatementsArgs args, InvokeOptions? opts = null)
public static Output<GetManagedDatabaseCursorCacheStatementsResult> Invoke(GetManagedDatabaseCursorCacheStatementsInvokeArgs args, InvokeOptions? opts = null)
}
public static CompletableFuture<GetManagedDatabaseCursorCacheStatementsResult> getManagedDatabaseCursorCacheStatements(GetManagedDatabaseCursorCacheStatementsArgs args, InvokeOptions options)
// Output-based functions aren't available in Java yet
fn::invoke:
function: oci:DatabaseManagement/getManagedDatabaseCursorCacheStatements:getManagedDatabaseCursorCacheStatements
arguments:
# arguments dictionary
The following arguments are supported:
- Managed
Database stringId - The OCID of the Managed Database.
- Filters
List<Get
Managed Database Cursor Cache Statements Filter> - Limit int
- Opc
Named stringCredential Id - The OCID of the Named Credential.
- Sql
Text string - A filter to return all the SQL plan baselines that match the SQL text. By default, the search is case insensitive. To run an exact or case-sensitive search, double-quote the search string. You may also use the '%' symbol as a wildcard.
- Managed
Database stringId - The OCID of the Managed Database.
- Filters
[]Get
Managed Database Cursor Cache Statements Filter - Limit int
- Opc
Named stringCredential Id - The OCID of the Named Credential.
- Sql
Text string - A filter to return all the SQL plan baselines that match the SQL text. By default, the search is case insensitive. To run an exact or case-sensitive search, double-quote the search string. You may also use the '%' symbol as a wildcard.
- managed
Database StringId - The OCID of the Managed Database.
- filters
List<Get
Managed Database Cursor Cache Statements Filter> - limit Integer
- opc
Named StringCredential Id - The OCID of the Named Credential.
- sql
Text String - A filter to return all the SQL plan baselines that match the SQL text. By default, the search is case insensitive. To run an exact or case-sensitive search, double-quote the search string. You may also use the '%' symbol as a wildcard.
- managed
Database stringId - The OCID of the Managed Database.
- filters
Get
Managed Database Cursor Cache Statements Filter[] - limit number
- opc
Named stringCredential Id - The OCID of the Named Credential.
- sql
Text string - A filter to return all the SQL plan baselines that match the SQL text. By default, the search is case insensitive. To run an exact or case-sensitive search, double-quote the search string. You may also use the '%' symbol as a wildcard.
- managed_
database_ strid - The OCID of the Managed Database.
- filters
Sequence[databasemanagement.
Get Managed Database Cursor Cache Statements Filter] - limit int
- opc_
named_ strcredential_ id - The OCID of the Named Credential.
- sql_
text str - A filter to return all the SQL plan baselines that match the SQL text. By default, the search is case insensitive. To run an exact or case-sensitive search, double-quote the search string. You may also use the '%' symbol as a wildcard.
- managed
Database StringId - The OCID of the Managed Database.
- filters List<Property Map>
- limit Number
- opc
Named StringCredential Id - The OCID of the Named Credential.
- sql
Text String - A filter to return all the SQL plan baselines that match the SQL text. By default, the search is case insensitive. To run an exact or case-sensitive search, double-quote the search string. You may also use the '%' symbol as a wildcard.
getManagedDatabaseCursorCacheStatements Result
The following output properties are available:
- Cursor
Cache List<GetStatement Collections Managed Database Cursor Cache Statements Cursor Cache Statement Collection> - The list of cursor_cache_statement_collection.
- Id string
- The provider-assigned unique ID for this managed resource.
- Managed
Database stringId - Filters
List<Get
Managed Database Cursor Cache Statements Filter> - Limit int
- Opc
Named stringCredential Id - Sql
Text string - The first thousand characters of the SQL text.
- Cursor
Cache []GetStatement Collections Managed Database Cursor Cache Statements Cursor Cache Statement Collection - The list of cursor_cache_statement_collection.
- Id string
- The provider-assigned unique ID for this managed resource.
- Managed
Database stringId - Filters
[]Get
Managed Database Cursor Cache Statements Filter - Limit int
- Opc
Named stringCredential Id - Sql
Text string - The first thousand characters of the SQL text.
- cursor
Cache List<GetStatement Collections Managed Database Cursor Cache Statements Cursor Cache Statement Collection> - The list of cursor_cache_statement_collection.
- id String
- The provider-assigned unique ID for this managed resource.
- managed
Database StringId - filters
List<Get
Managed Database Cursor Cache Statements Filter> - limit Integer
- opc
Named StringCredential Id - sql
Text String - The first thousand characters of the SQL text.
- cursor
Cache GetStatement Collections Managed Database Cursor Cache Statements Cursor Cache Statement Collection[] - The list of cursor_cache_statement_collection.
- id string
- The provider-assigned unique ID for this managed resource.
- managed
Database stringId - filters
Get
Managed Database Cursor Cache Statements Filter[] - limit number
- opc
Named stringCredential Id - sql
Text string - The first thousand characters of the SQL text.
- cursor_
cache_ Sequence[databasemanagement.statement_ collections Get Managed Database Cursor Cache Statements Cursor Cache Statement Collection] - The list of cursor_cache_statement_collection.
- id str
- The provider-assigned unique ID for this managed resource.
- managed_
database_ strid - filters
Sequence[databasemanagement.
Get Managed Database Cursor Cache Statements Filter] - limit int
- opc_
named_ strcredential_ id - sql_
text str - The first thousand characters of the SQL text.
- cursor
Cache List<Property Map>Statement Collections - The list of cursor_cache_statement_collection.
- id String
- The provider-assigned unique ID for this managed resource.
- managed
Database StringId - filters List<Property Map>
- limit Number
- opc
Named StringCredential Id - sql
Text String - The first thousand characters of the SQL text.
Supporting Types
GetManagedDatabaseCursorCacheStatementsCursorCacheStatementCollection
- Items
List<Get
Managed Database Cursor Cache Statements Cursor Cache Statement Collection Item> - A list of SQL statements in the cursor cache.
- Items
[]Get
Managed Database Cursor Cache Statements Cursor Cache Statement Collection Item - A list of SQL statements in the cursor cache.
- items
List<Get
Managed Database Cursor Cache Statements Cursor Cache Statement Collection Item> - A list of SQL statements in the cursor cache.
- items
Get
Managed Database Cursor Cache Statements Cursor Cache Statement Collection Item[] - A list of SQL statements in the cursor cache.
- items
Sequence[databasemanagement.
Get Managed Database Cursor Cache Statements Cursor Cache Statement Collection Item] - A list of SQL statements in the cursor cache.
- items List<Property Map>
- A list of SQL statements in the cursor cache.
GetManagedDatabaseCursorCacheStatementsCursorCacheStatementCollectionItem
- Schema string
- The name of the parsing schema.
- Sql
Id string - The SQL statement identifier. Identifies a SQL statement in the cursor cache.
- Sql
Text string - A filter to return all the SQL plan baselines that match the SQL text. By default, the search is case insensitive. To run an exact or case-sensitive search, double-quote the search string. You may also use the '%' symbol as a wildcard.
- Schema string
- The name of the parsing schema.
- Sql
Id string - The SQL statement identifier. Identifies a SQL statement in the cursor cache.
- Sql
Text string - A filter to return all the SQL plan baselines that match the SQL text. By default, the search is case insensitive. To run an exact or case-sensitive search, double-quote the search string. You may also use the '%' symbol as a wildcard.
- schema String
- The name of the parsing schema.
- sql
Id String - The SQL statement identifier. Identifies a SQL statement in the cursor cache.
- sql
Text String - A filter to return all the SQL plan baselines that match the SQL text. By default, the search is case insensitive. To run an exact or case-sensitive search, double-quote the search string. You may also use the '%' symbol as a wildcard.
- schema string
- The name of the parsing schema.
- sql
Id string - The SQL statement identifier. Identifies a SQL statement in the cursor cache.
- sql
Text string - A filter to return all the SQL plan baselines that match the SQL text. By default, the search is case insensitive. To run an exact or case-sensitive search, double-quote the search string. You may also use the '%' symbol as a wildcard.
- schema str
- The name of the parsing schema.
- sql_
id str - The SQL statement identifier. Identifies a SQL statement in the cursor cache.
- sql_
text str - A filter to return all the SQL plan baselines that match the SQL text. By default, the search is case insensitive. To run an exact or case-sensitive search, double-quote the search string. You may also use the '%' symbol as a wildcard.
- schema String
- The name of the parsing schema.
- sql
Id String - The SQL statement identifier. Identifies a SQL statement in the cursor cache.
- sql
Text String - A filter to return all the SQL plan baselines that match the SQL text. By default, the search is case insensitive. To run an exact or case-sensitive search, double-quote the search string. You may also use the '%' symbol as a wildcard.
GetManagedDatabaseCursorCacheStatementsFilter
Package Details
- Repository
- oci pulumi/pulumi-oci
- License
- Apache-2.0
- Notes
- This Pulumi package is based on the
oci
Terraform Provider.