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 Description Builder()
-
Method Summary
-
-
-
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)
-
-