java.lang.Object
- com.oracle.bmc.databasemanagement.model.FetchSqlTuningSetDetails.Builder

Enclosing class:: FetchSqlTuningSetDetails

public static class FetchSqlTuningSetDetails.Builder
extends Object

Constructor Summary

Constructors
Constructor Description

Builder()

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method	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)
```

Class FetchSqlTuningSetDetails.Builder

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Constructor Detail

Builder

Method Detail

credentialDetails

databaseCredential

owner

name

basicFilter

recursiveSql

resultPercentage

resultLimit

rankingMeasure1

rankingMeasure2

rankingMeasure3

build

copy