import * as pulumi from "@pulumi/pulumi"; import * as outputs from "../types/output"; /** * This data source provides details about a specific Managed Database Sql Plan Baseline Configuration resource in Oracle Cloud Infrastructure Database Management service. * * Gets the configuration details of SQL plan baselines for the specified * Managed Database. The details include the settings for the capture and use of * SQL plan baselines, SPM Evolve Advisor task, and SQL Management Base. * * ## Example Usage * * ```typescript * import * as pulumi from "@pulumi/pulumi"; * import * as oci from "@pulumi/oci"; * * const testManagedDatabaseSqlPlanBaselineConfiguration = oci.databasemanagement.getManagedDatabaseSqlPlanBaselineConfiguration({ * managedDatabaseId: testManagedDatabase.id, * opcNamedCredentialId: managedDatabaseSqlPlanBaselineConfigurationOpcNamedCredentialId, * }); * ``` */ export declare function getManagedDatabaseSqlPlanBaselineConfiguration(args: GetManagedDatabaseSqlPlanBaselineConfigurationArgs, opts?: pulumi.InvokeOptions): Promise; /** * A collection of arguments for invoking getManagedDatabaseSqlPlanBaselineConfiguration. */ export interface GetManagedDatabaseSqlPlanBaselineConfigurationArgs { /** * 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 collection of values returned by getManagedDatabaseSqlPlanBaselineConfiguration. */ export interface GetManagedDatabaseSqlPlanBaselineConfigurationResult { /** * The capture filters used in automatic initial plan capture. */ readonly autoCaptureFilters: outputs.DatabaseManagement.GetManagedDatabaseSqlPlanBaselineConfigurationAutoCaptureFilter[]; /** * The set of parameters used in an SPM evolve task. */ readonly autoSpmEvolveTaskParameters: outputs.DatabaseManagement.GetManagedDatabaseSqlPlanBaselineConfigurationAutoSpmEvolveTaskParameter[]; /** * The provider-assigned unique ID for this managed resource. */ readonly id: string; /** * Indicates whether the Automatic SPM Evolve Advisor task is enabled (`true`) or not (`false`). */ readonly isAutoSpmEvolveTaskEnabled: boolean; /** * Indicates whether the automatic capture of SQL plan baselines is enabled (`true`) or not (`false`). */ readonly isAutomaticInitialPlanCaptureEnabled: boolean; /** * Indicates whether the high frequency Automatic SPM Evolve Advisor task is enabled (`true`) or not (`false`). */ readonly isHighFrequencyAutoSpmEvolveTaskEnabled: boolean; /** * Indicates whether the database uses SQL plan baselines (`true`) or not (`false`). */ readonly isSqlPlanBaselinesUsageEnabled: boolean; readonly managedDatabaseId: string; readonly opcNamedCredentialId?: string; /** * The number of weeks to retain unused plans before they are purged. */ readonly planRetentionWeeks: number; /** * The maximum `SYSAUX` space that can be used for SQL Management Base in MB. */ readonly spaceBudgetMb: number; /** * The maximum percent of `SYSAUX` space that can be used for SQL Management Base. */ readonly spaceBudgetPercent: number; /** * The space used by SQL Management Base in MB. */ readonly spaceUsedMb: number; } /** * This data source provides details about a specific Managed Database Sql Plan Baseline Configuration resource in Oracle Cloud Infrastructure Database Management service. * * Gets the configuration details of SQL plan baselines for the specified * Managed Database. The details include the settings for the capture and use of * SQL plan baselines, SPM Evolve Advisor task, and SQL Management Base. * * ## Example Usage * * ```typescript * import * as pulumi from "@pulumi/pulumi"; * import * as oci from "@pulumi/oci"; * * const testManagedDatabaseSqlPlanBaselineConfiguration = oci.databasemanagement.getManagedDatabaseSqlPlanBaselineConfiguration({ * managedDatabaseId: testManagedDatabase.id, * opcNamedCredentialId: managedDatabaseSqlPlanBaselineConfigurationOpcNamedCredentialId, * }); * ``` */ export declare function getManagedDatabaseSqlPlanBaselineConfigurationOutput(args: GetManagedDatabaseSqlPlanBaselineConfigurationOutputArgs, opts?: pulumi.InvokeOutputOptions): pulumi.Output; /** * A collection of arguments for invoking getManagedDatabaseSqlPlanBaselineConfiguration. */ export interface GetManagedDatabaseSqlPlanBaselineConfigurationOutputArgs { /** * 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; } //# sourceMappingURL=getManagedDatabaseSqlPlanBaselineConfiguration.d.ts.map