com.oracle.bmc.databasemanagement.model

Class FetchSqlTuningSetDetails.Builder

java.lang.Object

com.oracle.bmc.databasemanagement.model.FetchSqlTuningSetDetails.Builder

Enclosing class:

FetchSqlTuningSetDetails

public static class FetchSqlTuningSetDetails.Builder
extends Object

Constructor Summary

Constructors

Constructor and Description
Builder()

Method Summary

Modifier and Type	Method and Description
FetchSqlTuningSetDetails.Builder	basicFilter(String basicFilter) Specifies the Sql predicate to filter the Sql from the Sql tuning set defined on attributes of the SQLSET_ROW.
FetchSqlTuningSetDetails	build()
FetchSqlTuningSetDetails.Builder	copy(FetchSqlTuningSetDetails model)
FetchSqlTuningSetDetails.Builder	credentialDetails(SqlTuningSetAdminCredentialDetails credentialDetails)
FetchSqlTuningSetDetails.Builder	databaseCredential(DatabaseCredentialDetails databaseCredential)
FetchSqlTuningSetDetails.Builder	name(String name) The name of the Sql tuning set.
FetchSqlTuningSetDetails.Builder	owner(String owner) The owner of the Sql tuning set.
FetchSqlTuningSetDetails.Builder	rankingMeasure1(RankingMeasure rankingMeasure1) Specifies an ORDER BY clause on the selected Sql.
FetchSqlTuningSetDetails.Builder	rankingMeasure2(RankingMeasure rankingMeasure2) Specifies an ORDER BY clause on the selected Sql.
FetchSqlTuningSetDetails.Builder	rankingMeasure3(RankingMeasure rankingMeasure3) Specifies an ORDER BY clause on the selected Sql.
FetchSqlTuningSetDetails.Builder	recursiveSql(FetchSqlTuningSetDetails.RecursiveSql recursiveSql) Specifies that the filter must include recursive Sql in the Sql tuning set.
FetchSqlTuningSetDetails.Builder	resultLimit(Integer resultLimit) The top limit Sql from the filtered source, ranked by the ranking measure.
FetchSqlTuningSetDetails.Builder	resultPercentage(Double resultPercentage) Specifies a filter that picks the top n% according to the supplied ranking measure.

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

credentialDetails

public FetchSqlTuningSetDetails.Builder credentialDetails(SqlTuningSetAdminCredentialDetails credentialDetails)

databaseCredential

public FetchSqlTuningSetDetails.Builder databaseCredential(DatabaseCredentialDetails databaseCredential)

owner

public FetchSqlTuningSetDetails.Builder owner(String owner)

The owner of the Sql tuning set.

Parameters:

owner - the value to set

Returns:

this builder

name

public FetchSqlTuningSetDetails.Builder name(String name)

The name of the Sql tuning set.

Parameters:

name - the value to set

Returns:

this builder

basicFilter

public FetchSqlTuningSetDetails.Builder basicFilter(String basicFilter)

Specifies the Sql predicate to filter the Sql from the Sql tuning set defined on attributes of the SQLSET_ROW. User could use any combination of the following columns with appropriate values as Sql predicate Refer to the documentation https://docs.oracle.com/en/database/oracle/oracle-database/18/arpls/DBMS_SQLTUNE.html#GUID-1F4AFB03-7B29-46FC-B3F2-CB01EC36326C

Parameters:

basicFilter - the value to set

Returns:

this builder

recursiveSql

public FetchSqlTuningSetDetails.Builder recursiveSql(FetchSqlTuningSetDetails.RecursiveSql recursiveSql)

Specifies that the filter must include recursive Sql in the Sql tuning set.

Parameters:

recursiveSql - the value to set

Returns:

this builder

resultPercentage

public FetchSqlTuningSetDetails.Builder resultPercentage(Double resultPercentage)

Specifies a filter that picks the top n% according to the supplied ranking measure. Note that this parameter applies only if one ranking measure is supplied.

Parameters:

resultPercentage - the value to set

Returns:

this builder

resultLimit

public FetchSqlTuningSetDetails.Builder resultLimit(Integer resultLimit)

The top limit Sql from the filtered source, ranked by the ranking measure.

Parameters:

resultLimit - the value to set

Returns:

this builder

rankingMeasure1

public FetchSqlTuningSetDetails.Builder rankingMeasure1(RankingMeasure rankingMeasure1)

Specifies an ORDER BY clause on the selected Sql. User can specify upto three ranking measures.

Parameters:

rankingMeasure1 - the value to set

Returns:

this builder

rankingMeasure2

public FetchSqlTuningSetDetails.Builder rankingMeasure2(RankingMeasure rankingMeasure2)

Specifies an ORDER BY clause on the selected Sql. User can specify upto three ranking measures.

Parameters:

rankingMeasure2 - the value to set

Returns:

this builder

rankingMeasure3

public FetchSqlTuningSetDetails.Builder rankingMeasure3(RankingMeasure rankingMeasure3)

Specifies an ORDER BY clause on the selected Sql. User can specify upto three ranking measures.

Parameters:

rankingMeasure3 - the value to set

Returns:

this builder

build

public FetchSqlTuningSetDetails build()

copy

public FetchSqlTuningSetDetails.Builder copy(FetchSqlTuningSetDetails model)