Package com.oracle.bmc.databasemanagement.model

Class SqlPlanBaselineConfiguration.Builder

java.lang.Object

com.oracle.bmc.databasemanagement.model.SqlPlanBaselineConfiguration.Builder

Enclosing class:

SqlPlanBaselineConfiguration

public static class SqlPlanBaselineConfiguration.Builder
extends Object

Constructor Summary

Constructors

Constructor	Description
Builder()

Method Summary

Modifier and Type	Method	Description
SqlPlanBaselineConfiguration.Builder	autoCaptureFilters(List<AutomaticCaptureFilter> autoCaptureFilters)	The capture filters used in automatic initial plan capture.
SqlPlanBaselineConfiguration.Builder	autoSpmEvolveTaskParameters(SpmEvolveTaskParameters autoSpmEvolveTaskParameters)
SqlPlanBaselineConfiguration	build()
SqlPlanBaselineConfiguration.Builder	copy(SqlPlanBaselineConfiguration model)
SqlPlanBaselineConfiguration.Builder	isAutomaticInitialPlanCaptureEnabled(Boolean isAutomaticInitialPlanCaptureEnabled)	Indicates whether the automatic capture of SQL plan baselines is enabled (true) or not (false).
SqlPlanBaselineConfiguration.Builder	isAutoSpmEvolveTaskEnabled(Boolean isAutoSpmEvolveTaskEnabled)	Indicates whether the Automatic SPM Evolve Advisor task is enabled (true) or not (false).
SqlPlanBaselineConfiguration.Builder	isHighFrequencyAutoSpmEvolveTaskEnabled(Boolean isHighFrequencyAutoSpmEvolveTaskEnabled)	Indicates whether the high frequency Automatic SPM Evolve Advisor task is enabled ( true) or not (false).
SqlPlanBaselineConfiguration.Builder	isSqlPlanBaselinesUsageEnabled(Boolean isSqlPlanBaselinesUsageEnabled)	Indicates whether the database uses SQL plan baselines (true) or not ( false).
SqlPlanBaselineConfiguration.Builder	planRetentionWeeks(Integer planRetentionWeeks)	The number of weeks to retain unused plans before they are purged.
SqlPlanBaselineConfiguration.Builder	spaceBudgetMB(Float spaceBudgetMB)	The maximum SYSAUX space that can be used for SQL Management Base in MB.
SqlPlanBaselineConfiguration.Builder	spaceBudgetPercent(Float spaceBudgetPercent)	The maximum percent of SYSAUX space that can be used for SQL Management Base.
SqlPlanBaselineConfiguration.Builder	spaceUsedMB(Float spaceUsedMB)	The space used by SQL Management Base in MB.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

Builder

public Builder()

Method Detail

isAutomaticInitialPlanCaptureEnabled

public SqlPlanBaselineConfiguration.Builder isAutomaticInitialPlanCaptureEnabled(Boolean isAutomaticInitialPlanCaptureEnabled)

Indicates whether the automatic capture of SQL plan baselines is enabled (true) or not (false).

Parameters:

isAutomaticInitialPlanCaptureEnabled - the value to set

Returns:

this builder

isSqlPlanBaselinesUsageEnabled

public SqlPlanBaselineConfiguration.Builder isSqlPlanBaselinesUsageEnabled(Boolean isSqlPlanBaselinesUsageEnabled)

Indicates whether the database uses SQL plan baselines (true) or not ( false).

Parameters:

isSqlPlanBaselinesUsageEnabled - the value to set

Returns:

this builder

isAutoSpmEvolveTaskEnabled

public SqlPlanBaselineConfiguration.Builder isAutoSpmEvolveTaskEnabled(Boolean isAutoSpmEvolveTaskEnabled)

Indicates whether the Automatic SPM Evolve Advisor task is enabled (true) or not (false).

Parameters:

isAutoSpmEvolveTaskEnabled - the value to set

Returns:

this builder

isHighFrequencyAutoSpmEvolveTaskEnabled

public SqlPlanBaselineConfiguration.Builder isHighFrequencyAutoSpmEvolveTaskEnabled(Boolean isHighFrequencyAutoSpmEvolveTaskEnabled)

Indicates whether the high frequency Automatic SPM Evolve Advisor task is enabled ( true) or not (false).

Parameters:

isHighFrequencyAutoSpmEvolveTaskEnabled - the value to set

Returns:

this builder

planRetentionWeeks

public SqlPlanBaselineConfiguration.Builder planRetentionWeeks(Integer planRetentionWeeks)

The number of weeks to retain unused plans before they are purged.

Parameters:

planRetentionWeeks - the value to set

Returns:

this builder

spaceBudgetPercent

public SqlPlanBaselineConfiguration.Builder spaceBudgetPercent(Float spaceBudgetPercent)

The maximum percent of SYSAUX space that can be used for SQL Management Base.

Parameters:

spaceBudgetPercent - the value to set

Returns:

this builder

spaceBudgetMB

public SqlPlanBaselineConfiguration.Builder spaceBudgetMB(Float spaceBudgetMB)

The maximum SYSAUX space that can be used for SQL Management Base in MB.

Parameters:

spaceBudgetMB - the value to set

Returns:

this builder

spaceUsedMB

public SqlPlanBaselineConfiguration.Builder spaceUsedMB(Float spaceUsedMB)

The space used by SQL Management Base in MB.

Parameters:

spaceUsedMB - the value to set

Returns:

this builder

autoCaptureFilters

public SqlPlanBaselineConfiguration.Builder autoCaptureFilters(List<AutomaticCaptureFilter> autoCaptureFilters)

The capture filters used in automatic initial plan capture.

Parameters:

autoCaptureFilters - the value to set

Returns:

this builder

autoSpmEvolveTaskParameters

public SqlPlanBaselineConfiguration.Builder autoSpmEvolveTaskParameters(SpmEvolveTaskParameters autoSpmEvolveTaskParameters)

build

public SqlPlanBaselineConfiguration build()

copy

public SqlPlanBaselineConfiguration.Builder copy(SqlPlanBaselineConfiguration model)