com.oracle.bmc.databasemanagement.model

Class SqlPlanBaselineConfiguration

java.lang.Object

com.oracle.bmc.http.client.internal.ExplicitlySetBmcModel

com.oracle.bmc.databasemanagement.model.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).

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	SqlPlanBaselineConfiguration.Builder

Field Summary

Fields inherited from class com.oracle.bmc.http.client.internal.ExplicitlySetBmcModel

EXPLICITLY_SET_FILTER_NAME, EXPLICITLY_SET_PROPERTY_NAME

Constructor Summary

Constructors

Constructor and Description

SqlPlanBaselineConfiguration(Boolean isAutomaticInitialPlanCaptureEnabled, Boolean isSqlPlanBaselinesUsageEnabled, Boolean isAutoSpmEvolveTaskEnabled, Boolean isHighFrequencyAutoSpmEvolveTaskEnabled, Integer planRetentionWeeks, Float spaceBudgetPercent, Float spaceBudgetMB, Float spaceUsedMB, List<AutomaticCaptureFilter> autoCaptureFilters, SpmEvolveTaskParameters autoSpmEvolveTaskParameters) Deprecated.

Method Summary

Modifier and Type	Method and Description
static SqlPlanBaselineConfiguration.Builder	builder() Create a new builder.
boolean	equals(Object o)
List<AutomaticCaptureFilter>	getAutoCaptureFilters() The capture filters used in automatic initial plan capture.
SpmEvolveTaskParameters	getAutoSpmEvolveTaskParameters()
Boolean	getIsAutomaticInitialPlanCaptureEnabled() Indicates whether the automatic capture of SQL plan baselines is enabled (true) or not (false).
Boolean	getIsAutoSpmEvolveTaskEnabled() Indicates whether the Automatic SPM Evolve Advisor task is enabled (true) or not (false).
Boolean	getIsHighFrequencyAutoSpmEvolveTaskEnabled() Indicates whether the high frequency Automatic SPM Evolve Advisor task is enabled (true) or not (false).
Boolean	getIsSqlPlanBaselinesUsageEnabled() Indicates whether the database uses SQL plan baselines (true) or not (false).
Integer	getPlanRetentionWeeks() The number of weeks to retain unused plans before they are purged.
Float	getSpaceBudgetMB() The maximum SYSAUX space that can be used for SQL Management Base in MB.
Float	getSpaceBudgetPercent() The maximum percent of SYSAUX space that can be used for SQL Management Base.
Float	getSpaceUsedMB() The space used by SQL Management Base in MB.
int	hashCode()
SqlPlanBaselineConfiguration.Builder	toBuilder()
String	toString()
String	toString(boolean includeByteArrayContents) Return a string representation of the object.

Methods inherited from class com.oracle.bmc.http.client.internal.ExplicitlySetBmcModel

markPropertyAsExplicitlySet, wasPropertyExplicitlySet

Methods inherited from class java.lang.Object

clone, finalize, getClass, notify, notifyAll, wait, wait, wait

Constructor Detail

SqlPlanBaselineConfiguration

@Deprecated
 @ConstructorProperties(value={"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

builder

public static SqlPlanBaselineConfiguration.Builder builder()

Create a new builder.

toBuilder

public SqlPlanBaselineConfiguration.Builder toBuilder()

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

getAutoSpmEvolveTaskParameters

public SpmEvolveTaskParameters getAutoSpmEvolveTaskParameters()

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