Package com.oracle.bmc.databasemanagement.model

Class LoadSqlPlanBaselinesFromAwrDetails.Builder

java.lang.Object

com.oracle.bmc.databasemanagement.model.LoadSqlPlanBaselinesFromAwrDetails.Builder

Enclosing class:

LoadSqlPlanBaselinesFromAwrDetails

public static class LoadSqlPlanBaselinesFromAwrDetails.Builder
extends Object

Constructor Summary

Constructors

Constructor	Description
Builder()

Method Summary

Modifier and Type	Method	Description
LoadSqlPlanBaselinesFromAwrDetails.Builder	beginSnapshot(Integer beginSnapshot)	The begin snapshot.
LoadSqlPlanBaselinesFromAwrDetails	build()
LoadSqlPlanBaselinesFromAwrDetails.Builder	copy(LoadSqlPlanBaselinesFromAwrDetails model)
LoadSqlPlanBaselinesFromAwrDetails.Builder	credentials(ManagedDatabaseCredential credentials)
LoadSqlPlanBaselinesFromAwrDetails.Builder	databaseCredential(DatabaseCredentialDetails databaseCredential)
LoadSqlPlanBaselinesFromAwrDetails.Builder	endSnapshot(Integer endSnapshot)	The end snapshot.
LoadSqlPlanBaselinesFromAwrDetails.Builder	isEnabled(Boolean isEnabled)	Indicates whether the loaded plans are enabled (true) or not (false).
LoadSqlPlanBaselinesFromAwrDetails.Builder	isFixed(Boolean isFixed)	Indicates whether the plans are loaded as fixed plans (true) or non-fixed plans (false).
LoadSqlPlanBaselinesFromAwrDetails.Builder	jobDescription(String jobDescription)	The description of the job.
LoadSqlPlanBaselinesFromAwrDetails.Builder	jobName(String jobName)	The name of the database job used for loading SQL plan baselines.
LoadSqlPlanBaselinesFromAwrDetails.Builder	sqlTextFilter(String sqlTextFilter)	A filter applied to AWR to select only qualifying plans to be 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 LoadSqlPlanBaselinesFromAwrDetails.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 LoadSqlPlanBaselinesFromAwrDetails.Builder jobDescription(String jobDescription)

The description of the job.

Parameters:

jobDescription - the value to set

Returns:

this builder

beginSnapshot

public LoadSqlPlanBaselinesFromAwrDetails.Builder beginSnapshot(Integer beginSnapshot)

The begin snapshot.

Parameters:

beginSnapshot - the value to set

Returns:

this builder

endSnapshot

public LoadSqlPlanBaselinesFromAwrDetails.Builder endSnapshot(Integer endSnapshot)

The end snapshot.

Parameters:

endSnapshot - the value to set

Returns:

this builder

sqlTextFilter

public LoadSqlPlanBaselinesFromAwrDetails.Builder sqlTextFilter(String sqlTextFilter)

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 %’.

Parameters:

sqlTextFilter - the value to set

Returns:

this builder

isFixed

public LoadSqlPlanBaselinesFromAwrDetails.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 LoadSqlPlanBaselinesFromAwrDetails.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 LoadSqlPlanBaselinesFromAwrDetails.Builder credentials(ManagedDatabaseCredential credentials)

databaseCredential

public LoadSqlPlanBaselinesFromAwrDetails.Builder databaseCredential(DatabaseCredentialDetails databaseCredential)

build

public LoadSqlPlanBaselinesFromAwrDetails build()

copy

public LoadSqlPlanBaselinesFromAwrDetails.Builder copy(LoadSqlPlanBaselinesFromAwrDetails model)