Package com.oracle.bmc.databasemanagement.model

Class LoadSqlPlanBaselinesFromCursorCacheDetails.Builder

java.lang.Object

com.oracle.bmc.databasemanagement.model.LoadSqlPlanBaselinesFromCursorCacheDetails.Builder

Enclosing class:

LoadSqlPlanBaselinesFromCursorCacheDetails

public static class LoadSqlPlanBaselinesFromCursorCacheDetails.Builder
extends Object

Constructor Summary

Constructors

Constructor	Description
Builder()

Method Summary

Modifier and Type	Method	Description
LoadSqlPlanBaselinesFromCursorCacheDetails	build()
LoadSqlPlanBaselinesFromCursorCacheDetails.Builder	copy(LoadSqlPlanBaselinesFromCursorCacheDetails model)
LoadSqlPlanBaselinesFromCursorCacheDetails.Builder	credentials(ManagedDatabaseCredential credentials)
LoadSqlPlanBaselinesFromCursorCacheDetails.Builder	databaseCredential(DatabaseCredentialDetails databaseCredential)
LoadSqlPlanBaselinesFromCursorCacheDetails.Builder	filterName(LoadSqlPlanBaselinesFromCursorCacheDetails.FilterName filterName)	The name of the filter.
LoadSqlPlanBaselinesFromCursorCacheDetails.Builder	filterValue(String filterValue)	The filter value.
LoadSqlPlanBaselinesFromCursorCacheDetails.Builder	isEnabled(Boolean isEnabled)	Indicates whether the loaded plans are enabled (true) or not (false).
LoadSqlPlanBaselinesFromCursorCacheDetails.Builder	isFixed(Boolean isFixed)	Indicates whether the plans are loaded as fixed plans (true) or non-fixed plans (false).
LoadSqlPlanBaselinesFromCursorCacheDetails.Builder	jobDescription(String jobDescription)	The description of the job.
LoadSqlPlanBaselinesFromCursorCacheDetails.Builder	jobName(String jobName)	The name of the database job used for loading SQL plan baselines.
LoadSqlPlanBaselinesFromCursorCacheDetails.Builder	planHash(BigDecimal planHash)	The plan identifier.
LoadSqlPlanBaselinesFromCursorCacheDetails.Builder	sqlHandle(String sqlHandle)	The SQL handle to use in identifying the SQL plan baseline into which the plans are loaded.
LoadSqlPlanBaselinesFromCursorCacheDetails.Builder	sqlId(String sqlId)	The SQL statement identifier.
LoadSqlPlanBaselinesFromCursorCacheDetails.Builder	sqlText(String sqlText)	The SQL text to use in identifying the SQL plan baseline into which the plans are loaded.

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

jobName

public LoadSqlPlanBaselinesFromCursorCacheDetails.Builder jobName(String jobName)

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

Parameters:

jobName - the value to set

Returns:

this builder

jobDescription

public LoadSqlPlanBaselinesFromCursorCacheDetails.Builder jobDescription(String jobDescription)

The description of the job.

Parameters:

jobDescription - the value to set

Returns:

this builder

sqlId

public LoadSqlPlanBaselinesFromCursorCacheDetails.Builder sqlId(String sqlId)

The SQL statement identifier.

Identifies a SQL statement in the cursor cache.

Parameters:

sqlId - the value to set

Returns:

this builder

planHash

public LoadSqlPlanBaselinesFromCursorCacheDetails.Builder planHash(BigDecimal planHash)

The plan identifier.

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

Parameters:

planHash - the value to set

Returns:

this builder

sqlText

public LoadSqlPlanBaselinesFromCursorCacheDetails.Builder sqlText(String sqlText)

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.

Parameters:

sqlText - the value to set

Returns:

this builder

sqlHandle

public LoadSqlPlanBaselinesFromCursorCacheDetails.Builder sqlHandle(String sqlHandle)

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

Parameters:

sqlHandle - the value to set

Returns:

this builder

filterName

public LoadSqlPlanBaselinesFromCursorCacheDetails.Builder filterName(LoadSqlPlanBaselinesFromCursorCacheDetails.FilterName filterName)

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.

Parameters:

filterName - the value to set

Returns:

this builder

filterValue

public LoadSqlPlanBaselinesFromCursorCacheDetails.Builder filterValue(String filterValue)

The filter value.

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

Parameters:

filterValue - the value to set

Returns:

this builder

isFixed

public LoadSqlPlanBaselinesFromCursorCacheDetails.Builder isFixed(Boolean isFixed)

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

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

Parameters:

isFixed - the value to set

Returns:

this builder

isEnabled

public LoadSqlPlanBaselinesFromCursorCacheDetails.Builder isEnabled(Boolean isEnabled)

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

By default, they are enabled.

Parameters:

isEnabled - the value to set

Returns:

this builder

credentials

public LoadSqlPlanBaselinesFromCursorCacheDetails.Builder credentials(ManagedDatabaseCredential credentials)

databaseCredential

public LoadSqlPlanBaselinesFromCursorCacheDetails.Builder databaseCredential(DatabaseCredentialDetails databaseCredential)

build

public LoadSqlPlanBaselinesFromCursorCacheDetails build()

copy

public LoadSqlPlanBaselinesFromCursorCacheDetails.Builder copy(LoadSqlPlanBaselinesFromCursorCacheDetails model)