com.oracle.bmc.databasemanagement.model

Class StartSqlTuningTaskDetails.Builder

java.lang.Object

com.oracle.bmc.databasemanagement.model.StartSqlTuningTaskDetails.Builder

Enclosing class:

StartSqlTuningTaskDetails

public static class StartSqlTuningTaskDetails.Builder
extends Object

Constructor Summary

Constructors

Constructor and Description
Builder()

Method Summary

Modifier and Type	Method and Description
StartSqlTuningTaskDetails	build()
StartSqlTuningTaskDetails.Builder	copy(StartSqlTuningTaskDetails model)
StartSqlTuningTaskDetails.Builder	credentialDetails(SqlTuningTaskCredentialDetails credentialDetails)
StartSqlTuningTaskDetails.Builder	databaseCredential(DatabaseCredentialDetails databaseCredential)
StartSqlTuningTaskDetails.Builder	scope(StartSqlTuningTaskDetails.Scope scope) The scope for the SQL tuning task.
StartSqlTuningTaskDetails.Builder	sqlDetails(List<SqlTuningTaskSqlDetail> sqlDetails) The details of the SQL statement on which tuning is performed.
StartSqlTuningTaskDetails.Builder	sqlTuningSet(SqlTuningSetInput sqlTuningSet)
StartSqlTuningTaskDetails.Builder	statementTimeLimitInMinutes(Integer statementTimeLimitInMinutes) The time limit per SQL statement (in minutes).
StartSqlTuningTaskDetails.Builder	taskDescription(String taskDescription) The description of the SQL tuning task.
StartSqlTuningTaskDetails.Builder	taskName(String taskName) The name of the SQL tuning task.
StartSqlTuningTaskDetails.Builder	timeEnded(Date timeEnded) The end time of the period in which SQL statements are running.
StartSqlTuningTaskDetails.Builder	timeStarted(Date timeStarted) The start time of the period in which SQL statements are running.
StartSqlTuningTaskDetails.Builder	totalTimeLimitInMinutes(Integer totalTimeLimitInMinutes) The time limit for running the SQL tuning task.

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

taskName

public StartSqlTuningTaskDetails.Builder taskName(String taskName)

The name of the SQL tuning task. The name is unique per user in a database, and it is case-sensitive.

Parameters:

taskName - the value to set

Returns:

this builder

taskDescription

public StartSqlTuningTaskDetails.Builder taskDescription(String taskDescription)

The description of the SQL tuning task.

Parameters:

taskDescription - the value to set

Returns:

this builder

credentialDetails

public StartSqlTuningTaskDetails.Builder credentialDetails(SqlTuningTaskCredentialDetails credentialDetails)

databaseCredential

public StartSqlTuningTaskDetails.Builder databaseCredential(DatabaseCredentialDetails databaseCredential)

totalTimeLimitInMinutes

public StartSqlTuningTaskDetails.Builder totalTimeLimitInMinutes(Integer totalTimeLimitInMinutes)

The time limit for running the SQL tuning task.

Parameters:

totalTimeLimitInMinutes - the value to set

Returns:

this builder

scope

public StartSqlTuningTaskDetails.Builder scope(StartSqlTuningTaskDetails.Scope scope)

The scope for the SQL tuning task. For LIMITED scope, the SQL profile recommendation is excluded, so the task is executed faster. For COMPREHENSIVE scope, the SQL profile recommendation is included.

Parameters:

scope - the value to set

Returns:

this builder

statementTimeLimitInMinutes

public StartSqlTuningTaskDetails.Builder statementTimeLimitInMinutes(Integer statementTimeLimitInMinutes)

The time limit per SQL statement (in minutes). This is for a task with the COMPREHENSIVE scope. The time limit per SQL statement should not be more than the total time limit.

Parameters:

statementTimeLimitInMinutes - the value to set

Returns:

this builder

sqlTuningSet

public StartSqlTuningTaskDetails.Builder sqlTuningSet(SqlTuningSetInput sqlTuningSet)

sqlDetails

public StartSqlTuningTaskDetails.Builder sqlDetails(List<SqlTuningTaskSqlDetail> sqlDetails)

The details of the SQL statement on which tuning is performed. To obtain the details of the SQL statement, you must provide either the sqlTuningSet or the tuple of sqlDetails/timeStarted/timeEnded.

Parameters:

sqlDetails - the value to set

Returns:

this builder

timeStarted

public StartSqlTuningTaskDetails.Builder timeStarted(Date timeStarted)

The start time of the period in which SQL statements are running.

Parameters:

timeStarted - the value to set

Returns:

this builder

timeEnded

public StartSqlTuningTaskDetails.Builder timeEnded(Date timeEnded)

The end time of the period in which SQL statements are running.

Parameters:

timeEnded - the value to set

Returns:

this builder

build

public StartSqlTuningTaskDetails build()

copy

public StartSqlTuningTaskDetails.Builder copy(StartSqlTuningTaskDetails model)