Package com.oracle.bmc.databasemanagement.model

Class SqlPlanBaselineSummary

java.lang.Object

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

com.oracle.bmc.databasemanagement.model.SqlPlanBaselineSummary

@Generated(value="OracleSDKGenerator",
           comments="API Version: 20201101")
public final class SqlPlanBaselineSummary
extends com.oracle.bmc.http.client.internal.ExplicitlySetBmcModel

The summary of a SQL plan baseline.
Note: Objects should always be created or deserialized using the SqlPlanBaselineSummary.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 SqlPlanBaselineSummary.Builder, which maintain a set of all explicitly set fields called SqlPlanBaselineSummary.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	Description
static class	SqlPlanBaselineSummary.Accepted	Indicates whether the plan baseline is accepted (YES) or not (NO).
static class	SqlPlanBaselineSummary.Adaptive	Indicates whether a plan that is automatically captured by SQL plan management is marked adaptive or not.
static class	SqlPlanBaselineSummary.AutoPurge	Indicates whether the plan baseline is auto-purged (YES) or not (NO).
static class	SqlPlanBaselineSummary.Builder
static class	SqlPlanBaselineSummary.Enabled	Indicates whether the plan baseline is enabled (YES) or disabled (NO).
static class	SqlPlanBaselineSummary.Fixed	Indicates whether the plan baseline is fixed (YES) or not (NO).
static class	SqlPlanBaselineSummary.Reproduced	Indicates whether the optimizer was able to reproduce the plan (YES) or not ( NO).

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

Description

SqlPlanBaselineSummary(String planName, String sqlHandle, String sqlText, SqlPlanBaselineOrigin origin, Date timeCreated, Date timeLastModified, Date timeLastExecuted, SqlPlanBaselineSummary.Enabled enabled, SqlPlanBaselineSummary.Accepted accepted, SqlPlanBaselineSummary.Fixed fixed, SqlPlanBaselineSummary.Reproduced reproduced, SqlPlanBaselineSummary.AutoPurge autoPurge, SqlPlanBaselineSummary.Adaptive adaptive)

Deprecated.

Method Summary

Modifier and Type	Method	Description
static SqlPlanBaselineSummary.Builder	builder()	Create a new builder.
boolean	equals(Object o)
SqlPlanBaselineSummary.Accepted	getAccepted()	Indicates whether the plan baseline is accepted (YES) or not (NO).
SqlPlanBaselineSummary.Adaptive	getAdaptive()	Indicates whether a plan that is automatically captured by SQL plan management is marked adaptive or not.
SqlPlanBaselineSummary.AutoPurge	getAutoPurge()	Indicates whether the plan baseline is auto-purged (YES) or not (NO).
SqlPlanBaselineSummary.Enabled	getEnabled()	Indicates whether the plan baseline is enabled (YES) or disabled (NO).
SqlPlanBaselineSummary.Fixed	getFixed()	Indicates whether the plan baseline is fixed (YES) or not (NO).
SqlPlanBaselineOrigin	getOrigin()	The origin of the SQL plan baseline.
String	getPlanName()	The unique plan identifier.
SqlPlanBaselineSummary.Reproduced	getReproduced()	Indicates whether the optimizer was able to reproduce the plan (YES) or not ( NO).
String	getSqlHandle()	The unique SQL identifier.
String	getSqlText()	The SQL text (truncated to the first 50 characters).
Date	getTimeCreated()	The date and time when the plan baseline was created.
Date	getTimeLastExecuted()	The date and time when the plan baseline was last executed.
Date	getTimeLastModified()	The date and time when the plan baseline was last modified.
int	hashCode()
SqlPlanBaselineSummary.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

SqlPlanBaselineSummary

@Deprecated
@ConstructorProperties({"planName","sqlHandle","sqlText","origin","timeCreated","timeLastModified","timeLastExecuted","enabled","accepted","fixed","reproduced","autoPurge","adaptive"})
public SqlPlanBaselineSummary(String planName,
                              String sqlHandle,
                              String sqlText,
                              SqlPlanBaselineOrigin origin,
                              Date timeCreated,
                              Date timeLastModified,
                              Date timeLastExecuted,
                              SqlPlanBaselineSummary.Enabled enabled,
                              SqlPlanBaselineSummary.Accepted accepted,
                              SqlPlanBaselineSummary.Fixed fixed,
                              SqlPlanBaselineSummary.Reproduced reproduced,
                              SqlPlanBaselineSummary.AutoPurge autoPurge,
                              SqlPlanBaselineSummary.Adaptive adaptive)

Deprecated.

Method Detail

builder

public static SqlPlanBaselineSummary.Builder builder()

Create a new builder.

toBuilder

public SqlPlanBaselineSummary.Builder toBuilder()

getPlanName

public String getPlanName()

The unique plan identifier.

Returns:

the value

getSqlHandle

public String getSqlHandle()

The unique SQL identifier.

Returns:

the value

getSqlText

public String getSqlText()

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

Returns:

the value

getOrigin

public SqlPlanBaselineOrigin getOrigin()

The origin of the SQL plan baseline.

Returns:

the value

getTimeCreated

public Date getTimeCreated()

The date and time when the plan baseline was created.

Returns:

the value

getTimeLastModified

public Date getTimeLastModified()

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

Returns:

the value

getTimeLastExecuted

public Date getTimeLastExecuted()

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.

Returns:

the value

getEnabled

public SqlPlanBaselineSummary.Enabled getEnabled()

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

Returns:

the value

getAccepted

public SqlPlanBaselineSummary.Accepted getAccepted()

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

Returns:

the value

getFixed

public SqlPlanBaselineSummary.Fixed getFixed()

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

Returns:

the value

getReproduced

public SqlPlanBaselineSummary.Reproduced getReproduced()

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.

Returns:

the value

getAutoPurge

public SqlPlanBaselineSummary.AutoPurge getAutoPurge()

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

Returns:

the value

getAdaptive

public SqlPlanBaselineSummary.Adaptive getAdaptive()

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.

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