Package com.oracle.bmc.databasemanagement.model

Class LoadSqlPlanBaselinesFromCursorCacheDetails

java.lang.Object

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

com.oracle.bmc.databasemanagement.model.LoadSqlPlanBaselinesFromCursorCacheDetails

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

The details of SQL statements and plans to be loaded from cursor cache.

You can specify the plans to load using SQL ID, plan identifier, or filterName and filterValue pair. You can also control the SQL plan baseline into which the plans are loaded using either SQL text or SQL handle. It takes either credentials or databaseCredential. It’s recommended to provide databaseCredential
Note: Objects should always be created or deserialized using the LoadSqlPlanBaselinesFromCursorCacheDetails.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 LoadSqlPlanBaselinesFromCursorCacheDetails.Builder, which maintain a set of all explicitly set fields called LoadSqlPlanBaselinesFromCursorCacheDetails.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	LoadSqlPlanBaselinesFromCursorCacheDetails.Builder
static class	LoadSqlPlanBaselinesFromCursorCacheDetails.FilterName	The name of the filter.

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
LoadSqlPlanBaselinesFromCursorCacheDetails(String jobName, String jobDescription, String sqlId, BigDecimal planHash, String sqlText, String sqlHandle, LoadSqlPlanBaselinesFromCursorCacheDetails.FilterName filterName, String filterValue, Boolean isFixed, Boolean isEnabled, ManagedDatabaseCredential credentials, DatabaseCredentialDetails databaseCredential)	Deprecated.

Method Summary

Modifier and Type	Method	Description
static LoadSqlPlanBaselinesFromCursorCacheDetails.Builder	builder()	Create a new builder.
boolean	equals(Object o)
ManagedDatabaseCredential	getCredentials()
DatabaseCredentialDetails	getDatabaseCredential()
LoadSqlPlanBaselinesFromCursorCacheDetails.FilterName	getFilterName()	The name of the filter.
String	getFilterValue()	The filter value.
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.
BigDecimal	getPlanHash()	The plan identifier.
String	getSqlHandle()	The SQL handle to use in identifying the SQL plan baseline into which the plans are loaded.
String	getSqlId()	The SQL statement identifier.
String	getSqlText()	The SQL text to use in identifying the SQL plan baseline into which the plans are loaded.
int	hashCode()
LoadSqlPlanBaselinesFromCursorCacheDetails.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

LoadSqlPlanBaselinesFromCursorCacheDetails

@Deprecated
@ConstructorProperties({"jobName","jobDescription","sqlId","planHash","sqlText","sqlHandle","filterName","filterValue","isFixed","isEnabled","credentials","databaseCredential"})
public LoadSqlPlanBaselinesFromCursorCacheDetails(String jobName,
                                                  String jobDescription,
                                                  String sqlId,
                                                  BigDecimal planHash,
                                                  String sqlText,
                                                  String sqlHandle,
                                                  LoadSqlPlanBaselinesFromCursorCacheDetails.FilterName filterName,
                                                  String filterValue,
                                                  Boolean isFixed,
                                                  Boolean isEnabled,
                                                  ManagedDatabaseCredential credentials,
                                                  DatabaseCredentialDetails databaseCredential)

Deprecated.

Method Detail

builder

public static LoadSqlPlanBaselinesFromCursorCacheDetails.Builder builder()

Create a new builder.

toBuilder

public LoadSqlPlanBaselinesFromCursorCacheDetails.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

getSqlId

public String getSqlId()

The SQL statement identifier.

Identifies a SQL statement in the cursor cache.

Returns:

the value

getPlanHash

public BigDecimal getPlanHash()

The plan identifier.

By default, all plans present in the cursor cache for the SQL statement identified by sqlId are captured.

Returns:

the value

getSqlText

public String getSqlText()

The SQL text to use in identifying the SQL plan baseline into which the plans are loaded.

If the SQL plan baseline does not exist, it is created.

Returns:

the value

getSqlHandle

public String getSqlHandle()

The SQL handle to use in identifying the SQL plan baseline into which the plans are loaded.

Returns:

the value

getFilterName

public LoadSqlPlanBaselinesFromCursorCacheDetails.FilterName getFilterName()

The name of the filter.

- SQL_TEXT: Search pattern to apply to SQL text. - PARSING_SCHEMA_NAME: Name of the parsing schema. - MODULE: Name of the module. - ACTION: Name of the action.

Returns:

the value

getFilterValue

public String getFilterValue()

The filter value.

It is upper-cased except when it is enclosed in double quotes or filter name is SQL_TEXT.

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