import * as pulumi from "@pulumi/pulumi"; import * as inputs from "../types/input"; import * as outputs from "../types/output"; /** * 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 */ export declare function getManagedDatabaseSqlPlanBaselines(args: GetManagedDatabaseSqlPlanBaselinesArgs, opts?: pulumi.InvokeOptions): Promise; /** * A collection of arguments for invoking getManagedDatabaseSqlPlanBaselines. */ export interface GetManagedDatabaseSqlPlanBaselinesArgs { filters?: inputs.DatabaseManagement.GetManagedDatabaseSqlPlanBaselinesFilter[]; /** * A filter to return only SQL plan baselines that are either accepted or not accepted. By default, all SQL plan baselines are returned. */ isAccepted?: boolean; /** * A filter to return only SQL plan baselines that are either adaptive or not adaptive. By default, all SQL plan baselines are returned. */ isAdaptive?: 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. */ isAutoPurged?: boolean; /** * A filter to return only SQL plan baselines that are either enabled or not enabled. By default, all SQL plan baselines are returned. */ isEnabled?: boolean; /** * A filter to return only SQL plan baselines that are either fixed or not fixed. By default, all SQL plan baselines are returned. */ isFixed?: boolean; /** * A filter to return only SQL plan baselines that are not executed till now. By default, all SQL plan baselines are returned. */ isNeverExecuted?: 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. */ isReproduced?: boolean; limit?: number; /** * The [OCID](https://docs.cloud.oracle.com/iaas/Content/General/Concepts/identifiers.htm) of the Managed Database. */ managedDatabaseId: string; /** * The OCID of the Named Credential. */ opcNamedCredentialId?: string; /** * A filter to return all the SQL plan baselines that match the origin. */ origin?: string; /** * A filter to return only SQL plan baselines that match the plan name. */ planName?: string; /** * A filter to return all the SQL plan baselines for the specified SQL handle. */ sqlHandle?: 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. */ sqlText?: string; } /** * A collection of values returned by getManagedDatabaseSqlPlanBaselines. */ export interface GetManagedDatabaseSqlPlanBaselinesResult { readonly filters?: outputs.DatabaseManagement.GetManagedDatabaseSqlPlanBaselinesFilter[]; /** * The provider-assigned unique ID for this managed resource. */ readonly id: string; readonly isAccepted?: boolean; readonly isAdaptive?: boolean; readonly isAutoPurged?: boolean; readonly isEnabled?: boolean; readonly isFixed?: boolean; readonly isNeverExecuted?: boolean; readonly isReproduced?: boolean; readonly limit?: number; readonly managedDatabaseId: string; readonly opcNamedCredentialId?: string; /** * The origin of the SQL plan baseline. */ readonly origin?: string; /** * The unique plan identifier. */ readonly planName?: string; /** * The unique SQL identifier. */ readonly sqlHandle?: string; /** * The list of sql_plan_baseline_collection. */ readonly sqlPlanBaselineCollections: outputs.DatabaseManagement.GetManagedDatabaseSqlPlanBaselinesSqlPlanBaselineCollection[]; /** * The SQL text. */ readonly sqlText?: string; } /** * 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 */ export declare function getManagedDatabaseSqlPlanBaselinesOutput(args: GetManagedDatabaseSqlPlanBaselinesOutputArgs, opts?: pulumi.InvokeOutputOptions): pulumi.Output; /** * A collection of arguments for invoking getManagedDatabaseSqlPlanBaselines. */ export interface GetManagedDatabaseSqlPlanBaselinesOutputArgs { filters?: pulumi.Input[] | undefined>; /** * A filter to return only SQL plan baselines that are either accepted or not accepted. By default, all SQL plan baselines are returned. */ isAccepted?: pulumi.Input; /** * A filter to return only SQL plan baselines that are either adaptive or not adaptive. By default, all SQL plan baselines are returned. */ isAdaptive?: pulumi.Input; /** * 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. */ isAutoPurged?: pulumi.Input; /** * A filter to return only SQL plan baselines that are either enabled or not enabled. By default, all SQL plan baselines are returned. */ isEnabled?: pulumi.Input; /** * A filter to return only SQL plan baselines that are either fixed or not fixed. By default, all SQL plan baselines are returned. */ isFixed?: pulumi.Input; /** * A filter to return only SQL plan baselines that are not executed till now. By default, all SQL plan baselines are returned. */ isNeverExecuted?: pulumi.Input; /** * 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. */ isReproduced?: pulumi.Input; limit?: pulumi.Input; /** * The [OCID](https://docs.cloud.oracle.com/iaas/Content/General/Concepts/identifiers.htm) of the Managed Database. */ managedDatabaseId: pulumi.Input; /** * The OCID of the Named Credential. */ opcNamedCredentialId?: pulumi.Input; /** * A filter to return all the SQL plan baselines that match the origin. */ origin?: pulumi.Input; /** * A filter to return only SQL plan baselines that match the plan name. */ planName?: pulumi.Input; /** * A filter to return all the SQL plan baselines for the specified SQL handle. */ sqlHandle?: pulumi.Input; /** * 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. */ sqlText?: pulumi.Input; } //# sourceMappingURL=getManagedDatabaseSqlPlanBaselines.d.ts.map