1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. DatabaseManagement
  5. getManagedDatabaseSqlPlanBaselines
Oracle Cloud Infrastructure v2.2.0 published on Friday, Jul 12, 2024 by Pulumi

oci.DatabaseManagement.getManagedDatabaseSqlPlanBaselines

Explore with Pulumi AI

oci logo
Oracle Cloud Infrastructure v2.2.0 published on Friday, Jul 12, 2024 by Pulumi

    This data source provides the list of Managed Database Sql Plan Baselines in Oracle Cloud Infrastructure Database Management service.

    Lists the SQL plan baselines for the specified Managed Database.

    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

    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.
    oci logo
    Oracle Cloud Infrastructure v2.2.0 published on Friday, Jul 12, 2024 by Pulumi