Package com.oracle.bmc.databasemanagement.model

Class SqlPlanBaselineConfiguration

  • @Generated(value="OracleSDKGenerator",
           comments="API Version: 20201101")
public final class SqlPlanBaselineConfiguration
extends com.oracle.bmc.http.client.internal.ExplicitlySetBmcModel
    The configuration details of SQL plan baselines.

    The details include:

    - whether automatic initial plan capture is enabled or disabled - whether use of SQL plan baselines is enabled or disabled - whether Automatic SPM Evolve Advisor task is enabled or disabled - whether high-frequency Automatic SPM Evolve Advisor task is enabled or disabled - filters for the automatic initial plan capture - parameters for the Automatic SPM Evolve Advisor task - plan retention and allocated space for the plan baselines
    Note: Objects should always be created or deserialized using the SqlPlanBaselineConfiguration.Builder. This model distinguishes fields that are null because they are unset from fields that are explicitly set to null. This is done in the setter methods of the SqlPlanBaselineConfiguration.Builder, which maintain a set of all explicitly set fields called SqlPlanBaselineConfiguration.Builder.__explicitlySet__. The hashCode() and equals(Object) methods are implemented to take the explicitly set fields into account. The constructor, on the other hand, does not take the explicitly set fields into account (since the constructor cannot distinguish explicit null from unset null).

    • Constructor Detail

      • SqlPlanBaselineConfiguration

        @Deprecated
@ConstructorProperties({"isAutomaticInitialPlanCaptureEnabled","isSqlPlanBaselinesUsageEnabled","isAutoSpmEvolveTaskEnabled","isHighFrequencyAutoSpmEvolveTaskEnabled","planRetentionWeeks","spaceBudgetPercent","spaceBudgetMB","spaceUsedMB","autoCaptureFilters","autoSpmEvolveTaskParameters"})
public SqlPlanBaselineConfiguration​(Boolean isAutomaticInitialPlanCaptureEnabled,
                                    Boolean isSqlPlanBaselinesUsageEnabled,
                                    Boolean isAutoSpmEvolveTaskEnabled,
                                    Boolean isHighFrequencyAutoSpmEvolveTaskEnabled,
                                    Integer planRetentionWeeks,
                                    Float spaceBudgetPercent,
                                    Float spaceBudgetMB,
                                    Float spaceUsedMB,
                                    List<AutomaticCaptureFilter> autoCaptureFilters,
                                    SpmEvolveTaskParameters autoSpmEvolveTaskParameters)
        Deprecated.

    • Method Detail

      • getIsAutomaticInitialPlanCaptureEnabled

        public Boolean getIsAutomaticInitialPlanCaptureEnabled()
        Indicates whether the automatic capture of SQL plan baselines is enabled (true) or not (false).
        Returns:
        the value

      • getIsSqlPlanBaselinesUsageEnabled

        public Boolean getIsSqlPlanBaselinesUsageEnabled()
        Indicates whether the database uses SQL plan baselines (true) or not (false).
        Returns:
        the value

      • getIsAutoSpmEvolveTaskEnabled

        public Boolean getIsAutoSpmEvolveTaskEnabled()
        Indicates whether the Automatic SPM Evolve Advisor task is enabled (true) or not (false).
        Returns:
        the value

      • getIsHighFrequencyAutoSpmEvolveTaskEnabled

        public Boolean getIsHighFrequencyAutoSpmEvolveTaskEnabled()
        Indicates whether the high frequency Automatic SPM Evolve Advisor task is enabled ( true) or not (false).
        Returns:
        the value

      • getPlanRetentionWeeks

        public Integer getPlanRetentionWeeks()
        The number of weeks to retain unused plans before they are purged.
        Returns:
        the value

      • getSpaceBudgetPercent

        public Float getSpaceBudgetPercent()
        The maximum percent of SYSAUX space that can be used for SQL Management Base.
        Returns:
        the value

      • getSpaceBudgetMB

        public Float getSpaceBudgetMB()
        The maximum SYSAUX space that can be used for SQL Management Base in MB.
        Returns:
        the value

      • getSpaceUsedMB

        public Float getSpaceUsedMB()
        The space used by SQL Management Base in MB.
        Returns:
        the value

      • getAutoCaptureFilters

        public List<AutomaticCaptureFilter> getAutoCaptureFilters()
        The capture filters used in automatic initial plan capture.
        Returns:
        the value

      • toString

        public String toString()
        Overrides:
        toString in class com.oracle.bmc.http.client.internal.ExplicitlySetBmcModel

      • toString

        public String toString​(boolean includeByteArrayContents)
        Return a string representation of the object.
        Parameters:
        includeByteArrayContents - true to include the full contents of byte arrays
        Returns:
        string representation

      • equals

        public boolean equals​(Object o)
        Overrides:
        equals in class com.oracle.bmc.http.client.internal.ExplicitlySetBmcModel

      • hashCode

        public int hashCode()
        Overrides:
        hashCode in class com.oracle.bmc.http.client.internal.ExplicitlySetBmcModel