com.oracle.bmc.databasemanagement.model

Class SqlTuningSet.Builder

java.lang.Object

com.oracle.bmc.databasemanagement.model.SqlTuningSet.Builder

Enclosing class:

SqlTuningSet

public static class SqlTuningSet.Builder
extends Object

Constructor Summary

Constructors

Constructor and Description
Builder()

Method Summary

Modifier and Type	Method and Description
SqlTuningSet.Builder	allSqlStatementsFetched(SqlTuningSet.AllSqlStatementsFetched allSqlStatementsFetched) In OCI database management, there is a limit to fetch only 2000 rows.
SqlTuningSet	build()
SqlTuningSet.Builder	copy(SqlTuningSet model)
SqlTuningSet.Builder	description(String description) The description of the Sql tuning set.
SqlTuningSet.Builder	errorMessage(String errorMessage) Latest execution error of the plsql that was submitted as a scheduler job.
SqlTuningSet.Builder	id(Integer id) The unique Sql tuning set identifier.
SqlTuningSet.Builder	name(String name) The name of the Sql tuning set.
SqlTuningSet.Builder	owner(String owner) The owner of the Sql tuning set.
SqlTuningSet.Builder	scheduledJobName(String scheduledJobName) Name of the Sql tuning set scheduler job.
SqlTuningSet.Builder	sqlList(List<SqlInSqlTuningSet> sqlList) A list of the Sqls associated with the Sql tuning set.
SqlTuningSet.Builder	statementCount(Integer statementCount) Number of statements in the Sql tuning set
SqlTuningSet.Builder	status(SqlTuningSetStatusTypes status) Current status of the Sql tuning set.
SqlTuningSet.Builder	timeCreated(Date timeCreated) The created time of the Sql tuning set.
SqlTuningSet.Builder	timeLastModified(Date timeLastModified) Last modified time of the Sql tuning set.

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

id

public SqlTuningSet.Builder id(Integer id)

The unique Sql tuning set identifier.

Parameters:

id - the value to set

Returns:

this builder

owner

public SqlTuningSet.Builder owner(String owner)

The owner of the Sql tuning set.

Parameters:

owner - the value to set

Returns:

this builder

name

public SqlTuningSet.Builder name(String name)

The name of the Sql tuning set.

Parameters:

name - the value to set

Returns:

this builder

statementCount

public SqlTuningSet.Builder statementCount(Integer statementCount)

Number of statements in the Sql tuning set

Parameters:

statementCount - the value to set

Returns:

this builder

timeCreated

public SqlTuningSet.Builder timeCreated(Date timeCreated)

The created time of the Sql tuning set.

Parameters:

timeCreated - the value to set

Returns:

this builder

description

public SqlTuningSet.Builder description(String description)

The description of the Sql tuning set.

Parameters:

description - the value to set

Returns:

this builder

timeLastModified

public SqlTuningSet.Builder timeLastModified(Date timeLastModified)

Last modified time of the Sql tuning set.

Parameters:

timeLastModified - the value to set

Returns:

this builder

status

public SqlTuningSet.Builder status(SqlTuningSetStatusTypes status)

Current status of the Sql tuning set.

Parameters:

status - the value to set

Returns:

this builder

scheduledJobName

public SqlTuningSet.Builder scheduledJobName(String scheduledJobName)

Name of the Sql tuning set scheduler job.

Parameters:

scheduledJobName - the value to set

Returns:

this builder

errorMessage

public SqlTuningSet.Builder errorMessage(String errorMessage)

Latest execution error of the plsql that was submitted as a scheduler job.

Parameters:

errorMessage - the value to set

Returns:

this builder

allSqlStatementsFetched

public SqlTuningSet.Builder allSqlStatementsFetched(SqlTuningSet.AllSqlStatementsFetched allSqlStatementsFetched)

In OCI database management, there is a limit to fetch only 2000 rows. This flag indicates whether all Sql statements of this Sql tuning set matching the filter criteria are fetched or not. Possible values are ‘Yes’ or ‘No’ - Yes - All Sql statements matching the filter criteria are fetched. - No - There are more Sql statements matching the fitler criteria. User should fine tune the filter criteria to narrow down the result set.

Parameters:

allSqlStatementsFetched - the value to set

Returns:

this builder

sqlList

public SqlTuningSet.Builder sqlList(List<SqlInSqlTuningSet> sqlList)

A list of the Sqls associated with the Sql tuning set.

Parameters:

sqlList - the value to set

Returns:

this builder

build

public SqlTuningSet build()

copy

public SqlTuningSet.Builder copy(SqlTuningSet model)