Package com.oracle.bmc.databasemanagement.model

Class SqlPlanBaselineSummary.Builder

java.lang.Object

com.oracle.bmc.databasemanagement.model.SqlPlanBaselineSummary.Builder

Enclosing class:

SqlPlanBaselineSummary

public static class SqlPlanBaselineSummary.Builder
extends Object

Constructor Summary

Constructors

Constructor	Description
Builder()

Method Summary

Modifier and Type	Method	Description
SqlPlanBaselineSummary.Builder	accepted(SqlPlanBaselineSummary.Accepted accepted)	Indicates whether the plan baseline is accepted (YES) or not (NO).
SqlPlanBaselineSummary.Builder	adaptive(SqlPlanBaselineSummary.Adaptive adaptive)	Indicates whether a plan that is automatically captured by SQL plan management is marked adaptive or not.
SqlPlanBaselineSummary.Builder	autoPurge(SqlPlanBaselineSummary.AutoPurge autoPurge)	Indicates whether the plan baseline is auto-purged (YES) or not (NO).
SqlPlanBaselineSummary	build()
SqlPlanBaselineSummary.Builder	copy(SqlPlanBaselineSummary model)
SqlPlanBaselineSummary.Builder	enabled(SqlPlanBaselineSummary.Enabled enabled)	Indicates whether the plan baseline is enabled (YES) or disabled (NO).
SqlPlanBaselineSummary.Builder	fixed(SqlPlanBaselineSummary.Fixed fixed)	Indicates whether the plan baseline is fixed (YES) or not (NO).
SqlPlanBaselineSummary.Builder	origin(SqlPlanBaselineOrigin origin)	The origin of the SQL plan baseline.
SqlPlanBaselineSummary.Builder	planName(String planName)	The unique plan identifier.
SqlPlanBaselineSummary.Builder	reproduced(SqlPlanBaselineSummary.Reproduced reproduced)	Indicates whether the optimizer was able to reproduce the plan (YES) or not (NO).
SqlPlanBaselineSummary.Builder	sqlHandle(String sqlHandle)	The unique SQL identifier.
SqlPlanBaselineSummary.Builder	sqlText(String sqlText)	The SQL text (truncated to the first 50 characters).
SqlPlanBaselineSummary.Builder	timeCreated(Date timeCreated)	The date and time when the plan baseline was created.
SqlPlanBaselineSummary.Builder	timeLastExecuted(Date timeLastExecuted)	The date and time when the plan baseline was last executed.
SqlPlanBaselineSummary.Builder	timeLastModified(Date timeLastModified)	The date and time when the plan baseline was last modified.

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

planName

public SqlPlanBaselineSummary.Builder planName(String planName)

The unique plan identifier.

Parameters:

planName - the value to set

Returns:

this builder

sqlHandle

public SqlPlanBaselineSummary.Builder sqlHandle(String sqlHandle)

The unique SQL identifier.

Parameters:

sqlHandle - the value to set

Returns:

this builder

sqlText

public SqlPlanBaselineSummary.Builder sqlText(String sqlText)

The SQL text (truncated to the first 50 characters).

Parameters:

sqlText - the value to set

Returns:

this builder

origin

public SqlPlanBaselineSummary.Builder origin(SqlPlanBaselineOrigin origin)

The origin of the SQL plan baseline.

Parameters:

origin - the value to set

Returns:

this builder

timeCreated

public SqlPlanBaselineSummary.Builder timeCreated(Date timeCreated)

The date and time when the plan baseline was created.

Parameters:

timeCreated - the value to set

Returns:

this builder

timeLastModified

public SqlPlanBaselineSummary.Builder timeLastModified(Date timeLastModified)

The date and time when the plan baseline was last modified.

Parameters:

timeLastModified - the value to set

Returns:

this builder

timeLastExecuted

public SqlPlanBaselineSummary.Builder timeLastExecuted(Date timeLastExecuted)

The date and time when the plan baseline was last executed.

*Note:** For performance reasons, database does not update this value immediately after each execution of the plan baseline. Therefore, the plan baseline may have been executed more recently than this value indicates.

Parameters:

timeLastExecuted - the value to set

Returns:

this builder

enabled

public SqlPlanBaselineSummary.Builder enabled(SqlPlanBaselineSummary.Enabled enabled)

Indicates whether the plan baseline is enabled (YES) or disabled (NO).

Parameters:

enabled - the value to set

Returns:

this builder

accepted

public SqlPlanBaselineSummary.Builder accepted(SqlPlanBaselineSummary.Accepted accepted)

Indicates whether the plan baseline is accepted (YES) or not (NO).

Parameters:

accepted - the value to set

Returns:

this builder

fixed

public SqlPlanBaselineSummary.Builder fixed(SqlPlanBaselineSummary.Fixed fixed)

Indicates whether the plan baseline is fixed (YES) or not (NO).

Parameters:

fixed - the value to set

Returns:

this builder

reproduced

public SqlPlanBaselineSummary.Builder reproduced(SqlPlanBaselineSummary.Reproduced reproduced)

Indicates whether the optimizer was able to reproduce the plan (YES) or not (NO).

The value is set to YES when a plan is initially added to the plan baseline.

Parameters:

reproduced - the value to set

Returns:

this builder

autoPurge

public SqlPlanBaselineSummary.Builder autoPurge(SqlPlanBaselineSummary.AutoPurge autoPurge)

Indicates whether the plan baseline is auto-purged (YES) or not (NO).

Parameters:

autoPurge - the value to set

Returns:

this builder

adaptive

public SqlPlanBaselineSummary.Builder adaptive(SqlPlanBaselineSummary.Adaptive adaptive)

Indicates whether a plan that is automatically captured by SQL plan management is marked adaptive or not.

When a new adaptive plan is found for a SQL statement that has an existing SQL plan baseline, that new plan will be added to the SQL plan baseline as an unaccepted plan, and the ADAPTIVE property will be marked YES. When this new plan is verified (either manually or via the auto evolve task), the plan will be test executed and the final plan determined at execution will become an accepted plan if its performance is better than the existing plan baseline. At this point, the value of the ADAPTIVE property is set to NO since the plan is no longer adaptive, but resolved.

Parameters:

adaptive - the value to set

Returns:

this builder

build

public SqlPlanBaselineSummary build()

copy

public SqlPlanBaselineSummary.Builder copy(SqlPlanBaselineSummary model)