Oracle Cloud Infrastructure v1.34.0, May 3 24

Oracle Cloud Infrastructure v1.34.0 published on Friday, May 3, 2024 by Pulumi

oci.DatabaseManagement.getManagedDatabaseSqlPlanBaselines

Explore with Pulumi AI

Oracle Cloud Infrastructure v1.34.0 published on Friday, May 3, 2024 by Pulumi

Example Usage

Coming soon!

Coming soon!

Coming soon!

Coming soon!

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.GetManagedDatabaseSqlPlanBaselinesArgs;
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 testManagedDatabaseSqlPlanBaselines = DatabaseManagementFunctions.getManagedDatabaseSqlPlanBaselines(GetManagedDatabaseSqlPlanBaselinesArgs.builder()
            .managedDatabaseId(testManagedDatabase.id())
            .isAccepted(managedDatabaseSqlPlanBaselineIsAccepted)
            .isAdaptive(managedDatabaseSqlPlanBaselineIsAdaptive)
            .isAutoPurged(managedDatabaseSqlPlanBaselineIsAutoPurged)
            .isEnabled(managedDatabaseSqlPlanBaselineIsEnabled)
            .isFixed(managedDatabaseSqlPlanBaselineIsFixed)
            .isNeverExecuted(managedDatabaseSqlPlanBaselineIsNeverExecuted)
            .isReproduced(managedDatabaseSqlPlanBaselineIsReproduced)
            .opcNamedCredentialId(managedDatabaseSqlPlanBaselineOpcNamedCredentialId)
            .origin(managedDatabaseSqlPlanBaselineOrigin)
            .planName(managedDatabaseSqlPlanBaselinePlanName)
            .sqlHandle(managedDatabaseSqlPlanBaselineSqlHandle)
            .sqlText(managedDatabaseSqlPlanBaselineSqlText)
            .timeLastExecutedGreaterThan(managedDatabaseSqlPlanBaselineTimeLastExecutedGreaterThan)
            .timeLastExecutedLessThan(managedDatabaseSqlPlanBaselineTimeLastExecutedLessThan)
            .build());

    }
}

variables:
  testManagedDatabaseSqlPlanBaselines:
    fn::invoke:
      Function: oci:DatabaseManagement:getManagedDatabaseSqlPlanBaselines
      Arguments:
        managedDatabaseId: ${testManagedDatabase.id}
        isAccepted: ${managedDatabaseSqlPlanBaselineIsAccepted}
        isAdaptive: ${managedDatabaseSqlPlanBaselineIsAdaptive}
        isAutoPurged: ${managedDatabaseSqlPlanBaselineIsAutoPurged}
        isEnabled: ${managedDatabaseSqlPlanBaselineIsEnabled}
        isFixed: ${managedDatabaseSqlPlanBaselineIsFixed}
        isNeverExecuted: ${managedDatabaseSqlPlanBaselineIsNeverExecuted}
        isReproduced: ${managedDatabaseSqlPlanBaselineIsReproduced}
        opcNamedCredentialId: ${managedDatabaseSqlPlanBaselineOpcNamedCredentialId}
        origin: ${managedDatabaseSqlPlanBaselineOrigin}
        planName: ${managedDatabaseSqlPlanBaselinePlanName}
        sqlHandle: ${managedDatabaseSqlPlanBaselineSqlHandle}
        sqlText: ${managedDatabaseSqlPlanBaselineSqlText}
        timeLastExecutedGreaterThan: ${managedDatabaseSqlPlanBaselineTimeLastExecutedGreaterThan}
        timeLastExecutedLessThan: ${managedDatabaseSqlPlanBaselineTimeLastExecutedLessThan}

Using getManagedDatabaseSqlPlanBaselines

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 getManagedDatabaseSqlPlanBaselines(args: GetManagedDatabaseSqlPlanBaselinesArgs, opts?: InvokeOptions): Promise<GetManagedDatabaseSqlPlanBaselinesResult>
function getManagedDatabaseSqlPlanBaselinesOutput(args: GetManagedDatabaseSqlPlanBaselinesOutputArgs, opts?: InvokeOptions): Output<GetManagedDatabaseSqlPlanBaselinesResult>

def get_managed_database_sql_plan_baselines(filters: Optional[Sequence[_databasemanagement.GetManagedDatabaseSqlPlanBaselinesFilter]] = None,
                                            is_accepted: Optional[bool] = None,
                                            is_adaptive: Optional[bool] = None,
                                            is_auto_purged: Optional[bool] = None,
                                            is_enabled: Optional[bool] = None,
                                            is_fixed: Optional[bool] = None,
                                            is_never_executed: Optional[bool] = None,
                                            is_reproduced: Optional[bool] = None,
                                            limit: Optional[int] = None,
                                            managed_database_id: Optional[str] = None,
                                            opc_named_credential_id: Optional[str] = None,
                                            origin: Optional[str] = None,
                                            plan_name: Optional[str] = None,
                                            sql_handle: Optional[str] = None,
                                            sql_text: Optional[str] = None,
                                            opts: Optional[InvokeOptions] = None) -> GetManagedDatabaseSqlPlanBaselinesResult
def get_managed_database_sql_plan_baselines_output(filters: Optional[pulumi.Input[Sequence[pulumi.Input[_databasemanagement.GetManagedDatabaseSqlPlanBaselinesFilterArgs]]]] = None,
                                            is_accepted: Optional[pulumi.Input[bool]] = None,
                                            is_adaptive: Optional[pulumi.Input[bool]] = None,
                                            is_auto_purged: Optional[pulumi.Input[bool]] = None,
                                            is_enabled: Optional[pulumi.Input[bool]] = None,
                                            is_fixed: Optional[pulumi.Input[bool]] = None,
                                            is_never_executed: Optional[pulumi.Input[bool]] = None,
                                            is_reproduced: Optional[pulumi.Input[bool]] = None,
                                            limit: Optional[pulumi.Input[int]] = None,
                                            managed_database_id: Optional[pulumi.Input[str]] = None,
                                            opc_named_credential_id: Optional[pulumi.Input[str]] = None,
                                            origin: Optional[pulumi.Input[str]] = None,
                                            plan_name: Optional[pulumi.Input[str]] = None,
                                            sql_handle: Optional[pulumi.Input[str]] = None,
                                            sql_text: Optional[pulumi.Input[str]] = None,
                                            opts: Optional[InvokeOptions] = None) -> Output[GetManagedDatabaseSqlPlanBaselinesResult]

func GetManagedDatabaseSqlPlanBaselines(ctx *Context, args *GetManagedDatabaseSqlPlanBaselinesArgs, opts ...InvokeOption) (*GetManagedDatabaseSqlPlanBaselinesResult, error)
func GetManagedDatabaseSqlPlanBaselinesOutput(ctx *Context, args *GetManagedDatabaseSqlPlanBaselinesOutputArgs, opts ...InvokeOption) GetManagedDatabaseSqlPlanBaselinesResultOutput

> Note: This function is named GetManagedDatabaseSqlPlanBaselines in the Go SDK.

public static class GetManagedDatabaseSqlPlanBaselines 
{
    public static Task<GetManagedDatabaseSqlPlanBaselinesResult> InvokeAsync(GetManagedDatabaseSqlPlanBaselinesArgs args, InvokeOptions? opts = null)
    public static Output<GetManagedDatabaseSqlPlanBaselinesResult> Invoke(GetManagedDatabaseSqlPlanBaselinesInvokeArgs args, InvokeOptions? opts = null)
}

public static CompletableFuture<GetManagedDatabaseSqlPlanBaselinesResult> getManagedDatabaseSqlPlanBaselines(GetManagedDatabaseSqlPlanBaselinesArgs args, InvokeOptions options)
// Output-based functions aren't available in Java yet

fn::invoke:
  function: oci:DatabaseManagement/getManagedDatabaseSqlPlanBaselines:getManagedDatabaseSqlPlanBaselines
  arguments:
    # arguments dictionary

The following arguments are supported:

ManagedDatabaseId string: The OCID of the Managed Database.
Filters List<GetManagedDatabaseSqlPlanBaselinesFilter>
IsAccepted bool: A filter to return only SQL plan baselines that are either accepted or not accepted. By default, all SQL plan baselines are returned.
IsAdaptive bool: A filter to return only SQL plan baselines that are either adaptive or not adaptive. By default, all SQL plan baselines are returned.
IsAutoPurged bool: A filter to return only SQL plan baselines that are either auto-purged or not auto-purged. By default, all SQL plan baselines are returned.
IsEnabled bool: A filter to return only SQL plan baselines that are either enabled or not enabled. By default, all SQL plan baselines are returned.
IsFixed bool: A filter to return only SQL plan baselines that are either fixed or not fixed. By default, all SQL plan baselines are returned.
IsNeverExecuted bool: A filter to return only SQL plan baselines that are not executed till now. By default, all SQL plan baselines are returned.
IsReproduced bool: A filter to return only SQL plan baselines that were either reproduced or not reproduced by the optimizer. By default, all SQL plan baselines are returned.
Limit int
OpcNamedCredentialId string: The OCID of the Named Credential.
Origin string: A filter to return all the SQL plan baselines that match the origin.
PlanName string: A filter to return only SQL plan baselines that match the plan name.
SqlHandle string: A filter to return all the SQL plan baselines for the specified SQL handle.
SqlText 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.

ManagedDatabaseId string: The OCID of the Managed Database.
Filters []GetManagedDatabaseSqlPlanBaselinesFilter
IsAccepted bool: A filter to return only SQL plan baselines that are either accepted or not accepted. By default, all SQL plan baselines are returned.
IsAdaptive bool: A filter to return only SQL plan baselines that are either adaptive or not adaptive. By default, all SQL plan baselines are returned.
IsAutoPurged bool: A filter to return only SQL plan baselines that are either auto-purged or not auto-purged. By default, all SQL plan baselines are returned.
IsEnabled bool: A filter to return only SQL plan baselines that are either enabled or not enabled. By default, all SQL plan baselines are returned.
IsFixed bool: A filter to return only SQL plan baselines that are either fixed or not fixed. By default, all SQL plan baselines are returned.
IsNeverExecuted bool: A filter to return only SQL plan baselines that are not executed till now. By default, all SQL plan baselines are returned.
IsReproduced bool: A filter to return only SQL plan baselines that were either reproduced or not reproduced by the optimizer. By default, all SQL plan baselines are returned.
Limit int
OpcNamedCredentialId string: The OCID of the Named Credential.
Origin string: A filter to return all the SQL plan baselines that match the origin.
PlanName string: A filter to return only SQL plan baselines that match the plan name.
SqlHandle string: A filter to return all the SQL plan baselines for the specified SQL handle.
SqlText 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.

managedDatabaseId String: The OCID of the Managed Database.
filters List<GetManagedDatabaseSqlPlanBaselinesFilter>
isAccepted Boolean: A filter to return only SQL plan baselines that are either accepted or not accepted. By default, all SQL plan baselines are returned.
isAdaptive Boolean: A filter to return only SQL plan baselines that are either adaptive or not adaptive. By default, all SQL plan baselines are returned.
isAutoPurged Boolean: A filter to return only SQL plan baselines that are either auto-purged or not auto-purged. By default, all SQL plan baselines are returned.
isEnabled Boolean: A filter to return only SQL plan baselines that are either enabled or not enabled. By default, all SQL plan baselines are returned.
isFixed Boolean: A filter to return only SQL plan baselines that are either fixed or not fixed. By default, all SQL plan baselines are returned.
isNeverExecuted Boolean: A filter to return only SQL plan baselines that are not executed till now. By default, all SQL plan baselines are returned.
isReproduced Boolean: A filter to return only SQL plan baselines that were either reproduced or not reproduced by the optimizer. By default, all SQL plan baselines are returned.
limit Integer
opcNamedCredentialId String: The OCID of the Named Credential.
origin String: A filter to return all the SQL plan baselines that match the origin.
planName String: A filter to return only SQL plan baselines that match the plan name.
sqlHandle String: A filter to return all the SQL plan baselines for the specified SQL handle.
sqlText 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.

managedDatabaseId string: The OCID of the Managed Database.
filters GetManagedDatabaseSqlPlanBaselinesFilter[]
isAccepted boolean: A filter to return only SQL plan baselines that are either accepted or not accepted. By default, all SQL plan baselines are returned.
isAdaptive boolean: A filter to return only SQL plan baselines that are either adaptive or not adaptive. By default, all SQL plan baselines are returned.
isAutoPurged boolean: A filter to return only SQL plan baselines that are either auto-purged or not auto-purged. By default, all SQL plan baselines are returned.
isEnabled boolean: A filter to return only SQL plan baselines that are either enabled or not enabled. By default, all SQL plan baselines are returned.
isFixed boolean: A filter to return only SQL plan baselines that are either fixed or not fixed. By default, all SQL plan baselines are returned.
isNeverExecuted boolean: A filter to return only SQL plan baselines that are not executed till now. By default, all SQL plan baselines are returned.
isReproduced boolean: A filter to return only SQL plan baselines that were either reproduced or not reproduced by the optimizer. By default, all SQL plan baselines are returned.
limit number
opcNamedCredentialId string: The OCID of the Named Credential.
origin string: A filter to return all the SQL plan baselines that match the origin.
planName string: A filter to return only SQL plan baselines that match the plan name.
sqlHandle string: A filter to return all the SQL plan baselines for the specified SQL handle.
sqlText 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_id str: The OCID of the Managed Database.
filters Sequence[databasemanagement.GetManagedDatabaseSqlPlanBaselinesFilter]
is_accepted bool: A filter to return only SQL plan baselines that are either accepted or not accepted. By default, all SQL plan baselines are returned.
is_adaptive bool: A filter to return only SQL plan baselines that are either adaptive or not adaptive. By default, all SQL plan baselines are returned.
is_auto_purged bool: A filter to return only SQL plan baselines that are either auto-purged or not auto-purged. By default, all SQL plan baselines are returned.
is_enabled bool: A filter to return only SQL plan baselines that are either enabled or not enabled. By default, all SQL plan baselines are returned.
is_fixed bool: A filter to return only SQL plan baselines that are either fixed or not fixed. By default, all SQL plan baselines are returned.
is_never_executed bool: A filter to return only SQL plan baselines that are not executed till now. By default, all SQL plan baselines are returned.
is_reproduced bool: A filter to return only SQL plan baselines that were either reproduced or not reproduced by the optimizer. By default, all SQL plan baselines are returned.
limit int
opc_named_credential_id str: The OCID of the Named Credential.
origin str: A filter to return all the SQL plan baselines that match the origin.
plan_name str: A filter to return only SQL plan baselines that match the plan name.
sql_handle str: A filter to return all the SQL plan baselines for the specified SQL handle.
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.

managedDatabaseId String: The OCID of the Managed Database.
filters List<Property Map>
isAccepted Boolean: A filter to return only SQL plan baselines that are either accepted or not accepted. By default, all SQL plan baselines are returned.
isAdaptive Boolean: A filter to return only SQL plan baselines that are either adaptive or not adaptive. By default, all SQL plan baselines are returned.
isAutoPurged Boolean: A filter to return only SQL plan baselines that are either auto-purged or not auto-purged. By default, all SQL plan baselines are returned.
isEnabled Boolean: A filter to return only SQL plan baselines that are either enabled or not enabled. By default, all SQL plan baselines are returned.
isFixed Boolean: A filter to return only SQL plan baselines that are either fixed or not fixed. By default, all SQL plan baselines are returned.
isNeverExecuted Boolean: A filter to return only SQL plan baselines that are not executed till now. By default, all SQL plan baselines are returned.
isReproduced Boolean: A filter to return only SQL plan baselines that were either reproduced or not reproduced by the optimizer. By default, all SQL plan baselines are returned.
limit Number
opcNamedCredentialId String: The OCID of the Named Credential.
origin String: A filter to return all the SQL plan baselines that match the origin.
planName String: A filter to return only SQL plan baselines that match the plan name.
sqlHandle String: A filter to return all the SQL plan baselines for the specified SQL handle.
sqlText 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.

getManagedDatabaseSqlPlanBaselines Result

The following output properties are available:

Id string: The provider-assigned unique ID for this managed resource.
ManagedDatabaseId string
SqlPlanBaselineCollections List<GetManagedDatabaseSqlPlanBaselinesSqlPlanBaselineCollection>: The list of sql_plan_baseline_collection.
Filters List<GetManagedDatabaseSqlPlanBaselinesFilter>
IsAccepted bool
IsAdaptive bool
IsAutoPurged bool
IsEnabled bool
IsFixed bool
IsNeverExecuted bool
IsReproduced bool
Limit int
OpcNamedCredentialId string
Origin string: The origin of the SQL plan baseline.
PlanName string: The unique plan identifier.
SqlHandle string: The unique SQL identifier.
SqlText string: The SQL text.

Id string: The provider-assigned unique ID for this managed resource.
ManagedDatabaseId string
SqlPlanBaselineCollections []GetManagedDatabaseSqlPlanBaselinesSqlPlanBaselineCollection: The list of sql_plan_baseline_collection.
Filters []GetManagedDatabaseSqlPlanBaselinesFilter
IsAccepted bool
IsAdaptive bool
IsAutoPurged bool
IsEnabled bool
IsFixed bool
IsNeverExecuted bool
IsReproduced bool
Limit int
OpcNamedCredentialId string
Origin string: The origin of the SQL plan baseline.
PlanName string: The unique plan identifier.
SqlHandle string: The unique SQL identifier.
SqlText string: The SQL text.

id String: The provider-assigned unique ID for this managed resource.
managedDatabaseId String
sqlPlanBaselineCollections List<GetManagedDatabaseSqlPlanBaselinesSqlPlanBaselineCollection>: The list of sql_plan_baseline_collection.
filters List<GetManagedDatabaseSqlPlanBaselinesFilter>
isAccepted Boolean
isAdaptive Boolean
isAutoPurged Boolean
isEnabled Boolean
isFixed Boolean
isNeverExecuted Boolean
isReproduced Boolean
limit Integer
opcNamedCredentialId String
origin String: The origin of the SQL plan baseline.
planName String: The unique plan identifier.
sqlHandle String: The unique SQL identifier.
sqlText String: The SQL text.

id string: The provider-assigned unique ID for this managed resource.
managedDatabaseId string
sqlPlanBaselineCollections GetManagedDatabaseSqlPlanBaselinesSqlPlanBaselineCollection[]: The list of sql_plan_baseline_collection.
filters GetManagedDatabaseSqlPlanBaselinesFilter[]
isAccepted boolean
isAdaptive boolean
isAutoPurged boolean
isEnabled boolean
isFixed boolean
isNeverExecuted boolean
isReproduced boolean
limit number
opcNamedCredentialId string
origin string: The origin of the SQL plan baseline.
planName string: The unique plan identifier.
sqlHandle string: The unique SQL identifier.
sqlText string: The SQL text.

id str: The provider-assigned unique ID for this managed resource.
managed_database_id str
sql_plan_baseline_collections Sequence[databasemanagement.GetManagedDatabaseSqlPlanBaselinesSqlPlanBaselineCollection]: The list of sql_plan_baseline_collection.
filters Sequence[databasemanagement.GetManagedDatabaseSqlPlanBaselinesFilter]
is_accepted bool
is_adaptive bool
is_auto_purged bool
is_enabled bool
is_fixed bool
is_never_executed bool
is_reproduced bool
limit int
opc_named_credential_id str
origin str: The origin of the SQL plan baseline.
plan_name str: The unique plan identifier.
sql_handle str: The unique SQL identifier.
sql_text str: The SQL text.

id String: The provider-assigned unique ID for this managed resource.
managedDatabaseId String
sqlPlanBaselineCollections List<Property Map>: The list of sql_plan_baseline_collection.
filters List<Property Map>
isAccepted Boolean
isAdaptive Boolean
isAutoPurged Boolean
isEnabled Boolean
isFixed Boolean
isNeverExecuted Boolean
isReproduced Boolean
limit Number
opcNamedCredentialId String
origin String: The origin of the SQL plan baseline.
planName String: The unique plan identifier.
sqlHandle String: The unique SQL identifier.
sqlText String: The SQL text.

Supporting Types

GetManagedDatabaseSqlPlanBaselinesFilter

Name string
Values List<string>
Regex bool

Name string
Values []string
Regex bool

name String
values List<String>
regex Boolean

name string
values string[]
regex boolean

name str
values Sequence[str]
regex bool

name String
values List<String>
regex Boolean

GetManagedDatabaseSqlPlanBaselinesSqlPlanBaselineCollection

Items List<GetManagedDatabaseSqlPlanBaselinesSqlPlanBaselineCollectionItem>

Items []GetManagedDatabaseSqlPlanBaselinesSqlPlanBaselineCollectionItem

items List<GetManagedDatabaseSqlPlanBaselinesSqlPlanBaselineCollectionItem>

items GetManagedDatabaseSqlPlanBaselinesSqlPlanBaselineCollectionItem[]

items Sequence[databasemanagement.GetManagedDatabaseSqlPlanBaselinesSqlPlanBaselineCollectionItem]

items List<Property Map>

GetManagedDatabaseSqlPlanBaselinesSqlPlanBaselineCollectionItem

Accepted string: Indicates whether the plan baseline is accepted (YES) or not (NO).
Action string: The application action.
Adaptive string: Indicates whether a plan that is automatically captured by SQL plan management is marked adaptive or not.
AutoPurge string: Indicates whether the plan baseline is auto-purged (YES) or not (NO).
Enabled string: Indicates whether the plan baseline is enabled (YES) or disabled (NO).
ExecutionPlan string: The execution plan for the SQL statement.
Fixed string: Indicates whether the plan baseline is fixed (YES) or not (NO).
Module string: The application module name.
Origin string: A filter to return all the SQL plan baselines that match the origin.
PlanName string: A filter to return only SQL plan baselines that match the plan name.
Reproduced string: Indicates whether the optimizer was able to reproduce the plan (YES) or not (NO). The value is set to YES when a plan is initially added to the plan baseline.
SqlHandle string: A filter to return all the SQL plan baselines for the specified SQL handle.
SqlText 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.
TimeCreated string: The date and time when the plan baseline was created.
TimeLastExecuted string: The date and time when the plan baseline was last executed.
TimeLastModified string: The date and time when the plan baseline was last modified.

Accepted string: Indicates whether the plan baseline is accepted (YES) or not (NO).
Action string: The application action.
Adaptive string: Indicates whether a plan that is automatically captured by SQL plan management is marked adaptive or not.
AutoPurge string: Indicates whether the plan baseline is auto-purged (YES) or not (NO).
Enabled string: Indicates whether the plan baseline is enabled (YES) or disabled (NO).
ExecutionPlan string: The execution plan for the SQL statement.
Fixed string: Indicates whether the plan baseline is fixed (YES) or not (NO).
Module string: The application module name.
Origin string: A filter to return all the SQL plan baselines that match the origin.
PlanName string: A filter to return only SQL plan baselines that match the plan name.
Reproduced string: Indicates whether the optimizer was able to reproduce the plan (YES) or not (NO). The value is set to YES when a plan is initially added to the plan baseline.
SqlHandle string: A filter to return all the SQL plan baselines for the specified SQL handle.
SqlText 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.
TimeCreated string: The date and time when the plan baseline was created.
TimeLastExecuted string: The date and time when the plan baseline was last executed.
TimeLastModified string: The date and time when the plan baseline was last modified.

accepted String: Indicates whether the plan baseline is accepted (YES) or not (NO).
action String: The application action.
adaptive String: Indicates whether a plan that is automatically captured by SQL plan management is marked adaptive or not.
autoPurge String: Indicates whether the plan baseline is auto-purged (YES) or not (NO).
enabled String: Indicates whether the plan baseline is enabled (YES) or disabled (NO).
executionPlan String: The execution plan for the SQL statement.
fixed String: Indicates whether the plan baseline is fixed (YES) or not (NO).
module String: The application module name.
origin String: A filter to return all the SQL plan baselines that match the origin.
planName String: A filter to return only SQL plan baselines that match the plan name.
reproduced String: Indicates whether the optimizer was able to reproduce the plan (YES) or not (NO). The value is set to YES when a plan is initially added to the plan baseline.
sqlHandle String: A filter to return all the SQL plan baselines for the specified SQL handle.
sqlText 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.
timeCreated String: The date and time when the plan baseline was created.
timeLastExecuted String: The date and time when the plan baseline was last executed.
timeLastModified String: The date and time when the plan baseline was last modified.

accepted string: Indicates whether the plan baseline is accepted (YES) or not (NO).
action string: The application action.
adaptive string: Indicates whether a plan that is automatically captured by SQL plan management is marked adaptive or not.
autoPurge string: Indicates whether the plan baseline is auto-purged (YES) or not (NO).
enabled string: Indicates whether the plan baseline is enabled (YES) or disabled (NO).
executionPlan string: The execution plan for the SQL statement.
fixed string: Indicates whether the plan baseline is fixed (YES) or not (NO).
module string: The application module name.
origin string: A filter to return all the SQL plan baselines that match the origin.
planName string: A filter to return only SQL plan baselines that match the plan name.
reproduced string: Indicates whether the optimizer was able to reproduce the plan (YES) or not (NO). The value is set to YES when a plan is initially added to the plan baseline.
sqlHandle string: A filter to return all the SQL plan baselines for the specified SQL handle.
sqlText 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.
timeCreated string: The date and time when the plan baseline was created.
timeLastExecuted string: The date and time when the plan baseline was last executed.
timeLastModified string: The date and time when the plan baseline was last modified.

accepted str: Indicates whether the plan baseline is accepted (YES) or not (NO).
action str: The application action.
adaptive str: Indicates whether a plan that is automatically captured by SQL plan management is marked adaptive or not.
auto_purge str: Indicates whether the plan baseline is auto-purged (YES) or not (NO).
enabled str: Indicates whether the plan baseline is enabled (YES) or disabled (NO).
execution_plan str: The execution plan for the SQL statement.
fixed str: Indicates whether the plan baseline is fixed (YES) or not (NO).
module str: The application module name.
origin str: A filter to return all the SQL plan baselines that match the origin.
plan_name str: A filter to return only SQL plan baselines that match the plan name.
reproduced str: Indicates whether the optimizer was able to reproduce the plan (YES) or not (NO). The value is set to YES when a plan is initially added to the plan baseline.
sql_handle str: A filter to return all the SQL plan baselines for the specified SQL handle.
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.
time_created str: The date and time when the plan baseline was created.
time_last_executed str: The date and time when the plan baseline was last executed.
time_last_modified str: The date and time when the plan baseline was last modified.

accepted String: Indicates whether the plan baseline is accepted (YES) or not (NO).
action String: The application action.
adaptive String: Indicates whether a plan that is automatically captured by SQL plan management is marked adaptive or not.
autoPurge String: Indicates whether the plan baseline is auto-purged (YES) or not (NO).
enabled String: Indicates whether the plan baseline is enabled (YES) or disabled (NO).
executionPlan String: The execution plan for the SQL statement.
fixed String: Indicates whether the plan baseline is fixed (YES) or not (NO).
module String: The application module name.
origin String: A filter to return all the SQL plan baselines that match the origin.
planName String: A filter to return only SQL plan baselines that match the plan name.
reproduced String: Indicates whether the optimizer was able to reproduce the plan (YES) or not (NO). The value is set to YES when a plan is initially added to the plan baseline.
sqlHandle String: A filter to return all the SQL plan baselines for the specified SQL handle.
sqlText 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.
timeCreated String: The date and time when the plan baseline was created.
timeLastExecuted String: The date and time when the plan baseline was last executed.
timeLastModified String: The date and time when the plan baseline was last modified.

Package Details

Repository: oci pulumi/pulumi-oci
License: Apache-2.0
Notes: This Pulumi package is based on the oci Terraform Provider.

Oracle Cloud Infrastructure v1.34.0 published on Friday, May 3, 2024 by Pulumi

pulumi/pulumi-oci

oci.DatabaseManagement.getManagedDatabaseSqlPlanBaselines

On this page

On this page

Example Usage

Using getManagedDatabaseSqlPlanBaselines

getManagedDatabaseSqlPlanBaselines Result

Supporting Types

GetManagedDatabaseSqlPlanBaselinesFilter

GetManagedDatabaseSqlPlanBaselinesSqlPlanBaselineCollection

GetManagedDatabaseSqlPlanBaselinesSqlPlanBaselineCollectionItem

Package Details

On this page

On this page