Package com.oracle.bmc.databasemanagement.model

Class LoadSqlPlanBaselinesFromAwrDetails

java.lang.Object

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

com.oracle.bmc.databasemanagement.model.LoadSqlPlanBaselinesFromAwrDetails

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

The details required to load plans from Automatic Workload Repository (AWR).

It takes either credentials or databaseCredential. It’s recommended to provide databaseCredential
Note: Objects should always be created or deserialized using the LoadSqlPlanBaselinesFromAwrDetails.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 LoadSqlPlanBaselinesFromAwrDetails.Builder, which maintain a set of all explicitly set fields called LoadSqlPlanBaselinesFromAwrDetails.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	LoadSqlPlanBaselinesFromAwrDetails.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	Description
LoadSqlPlanBaselinesFromAwrDetails(String jobName, String jobDescription, Integer beginSnapshot, Integer endSnapshot, String sqlTextFilter, Boolean isFixed, Boolean isEnabled, ManagedDatabaseCredential credentials, DatabaseCredentialDetails databaseCredential)	Deprecated.

Method Summary

Modifier and Type	Method	Description
static LoadSqlPlanBaselinesFromAwrDetails.Builder	builder()	Create a new builder.
boolean	equals(Object o)
Integer	getBeginSnapshot()	The begin snapshot.
ManagedDatabaseCredential	getCredentials()
DatabaseCredentialDetails	getDatabaseCredential()
Integer	getEndSnapshot()	The end snapshot.
Boolean	getIsEnabled()	Indicates whether the loaded plans are enabled (true) or not (false).
Boolean	getIsFixed()	Indicates whether the plans are loaded as fixed plans (true) or non-fixed plans (false).
String	getJobDescription()	The description of the job.
String	getJobName()	The name of the database job used for loading SQL plan baselines.
String	getSqlTextFilter()	A filter applied to AWR to select only qualifying plans to be loaded.
int	hashCode()
LoadSqlPlanBaselinesFromAwrDetails.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

LoadSqlPlanBaselinesFromAwrDetails

@Deprecated
@ConstructorProperties({"jobName","jobDescription","beginSnapshot","endSnapshot","sqlTextFilter","isFixed","isEnabled","credentials","databaseCredential"})
public LoadSqlPlanBaselinesFromAwrDetails(String jobName,
                                          String jobDescription,
                                          Integer beginSnapshot,
                                          Integer endSnapshot,
                                          String sqlTextFilter,
                                          Boolean isFixed,
                                          Boolean isEnabled,
                                          ManagedDatabaseCredential credentials,
                                          DatabaseCredentialDetails databaseCredential)

Deprecated.

Method Detail

builder

public static LoadSqlPlanBaselinesFromAwrDetails.Builder builder()

Create a new builder.

toBuilder

public LoadSqlPlanBaselinesFromAwrDetails.Builder toBuilder()

getJobName

public String getJobName()

The name of the database job used for loading SQL plan baselines.

Returns:

the value

getJobDescription

public String getJobDescription()

The description of the job.

Returns:

the value

getBeginSnapshot

public Integer getBeginSnapshot()

The begin snapshot.

Returns:

the value

getEndSnapshot

public Integer getEndSnapshot()

The end snapshot.

Returns:

the value

getSqlTextFilter

public String getSqlTextFilter()

A filter applied to AWR to select only qualifying plans to be loaded.

By default all plans in AWR are selected. The filter can take the form of any WHERE clause predicate that can be specified against the column DBA_HIST_SQLTEXT.SQL_TEXT. An example is sql_text like ‘SELECT %’.

Returns:

the value

getIsFixed

public Boolean getIsFixed()

Indicates whether the plans are loaded as fixed plans (true) or non-fixed plans (false).

By default, they are loaded as non-fixed plans.

Returns:

the value

getIsEnabled

public Boolean getIsEnabled()

Indicates whether the loaded plans are enabled (true) or not (false).

By default, they are enabled.

Returns:

the value

getCredentials

public ManagedDatabaseCredential getCredentials()

getDatabaseCredential

public DatabaseCredentialDetails getDatabaseCredential()

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