java.lang.Object
- com.oracle.bmc.http.client.internal.ExplicitlySetBmcModel
- - com.oracle.bmc.databasemanagement.model.SaveSqlTuningSetAsDetails

```
@Generated(value="OracleSDKGenerator",
           comments="API Version: 20201101")
public final class SaveSqlTuningSetAsDetails
extends com.oracle.bmc.http.client.internal.ExplicitlySetBmcModel
```
Save current list of Sql statements into another Sql tuning set.
It takes either credentialDetails or databaseCredential. It’s recommended to provide databaseCredential
Note: Objects should always be created or deserialized using the SaveSqlTuningSetAsDetails.Builder. This model distinguishes fields that are null because they are unset from fields that are explicitly set to null. This is done in the setter methods of the SaveSqlTuningSetAsDetails.Builder, which maintain a set of all explicitly set fields called SaveSqlTuningSetAsDetails.Builder.__explicitlySet__. The hashCode() and equals(Object) methods are implemented to take the explicitly set fields into account. The constructor, on the other hand, does not take the explicitly set fields into account (since the constructor cannot distinguish explicit null from unset null).

Nested Class Summary

Nested Classes
Modifier and Type	Class	Description
`static class`	`SaveSqlTuningSetAsDetails.Builder`
`static class`	`SaveSqlTuningSetAsDetails.LoadOption`	Specifies which statements are loaded into the Sql tuning set.
`static class`	`SaveSqlTuningSetAsDetails.PlanFilter`	Specifies the plan filter.
`static class`	`SaveSqlTuningSetAsDetails.RecursiveSql`	Specifies that the filter must include recursive Sql in the Sql tuning set.
`static class`	`SaveSqlTuningSetAsDetails.UpdateCondition`	Specifies when to perform the update.
`static class`	`SaveSqlTuningSetAsDetails.UpdateOption`	Specifies how existing Sql statements are updated.

Field Summary
- Fields inherited from class com.oracle.bmc.http.client.internal.ExplicitlySetBmcModel
  EXPLICITLY_SET_FILTER_NAME, EXPLICITLY_SET_PROPERTY_NAME

Constructor Summary

Constructors
Constructor	Description
SaveSqlTuningSetAsDetails(SqlTuningSetAdminCredentialDetails credentialDetails, DatabaseCredentialDetails databaseCredential, Integer showSqlOnly, String owner, String name, String destinationSqlTuningSetName, String destinationSqlTuningSetDescription, String destinationSqlTuningSetOwner, Integer createNew, String basicFilter, SaveSqlTuningSetAsDetails.PlanFilter planFilter, SaveSqlTuningSetAsDetails.RecursiveSql recursiveSql, Double resultPercentage, Integer resultLimit, RankingMeasure rankingMeasure1, RankingMeasure rankingMeasure2, RankingMeasure rankingMeasure3, String attributeList, SaveSqlTuningSetAsDetails.LoadOption loadOption, SaveSqlTuningSetAsDetails.UpdateOption updateOption, SaveSqlTuningSetAsDetails.UpdateCondition updateCondition, String updateAttributes, Boolean isIgnoreNull, Integer commitRows)	Deprecated.

Method Summary

All Methods Static Methods Instance Methods Concrete Methods
Modifier and Type	Method	Description
`static SaveSqlTuningSetAsDetails.Builder`	`builder()`	Create a new builder.
`boolean`	`equals(Object o)`
`String`	`getAttributeList()`	Specifies the list of Sql statement attributes to return in the result.
`String`	`getBasicFilter()`	Specifies the Sql predicate to filter the Sql from the Sql tuning set defined on attributes of the SQLSET_ROW.
`Integer`	`getCommitRows()`	Specifies whether to commit statements after DML.
`Integer`	`getCreateNew()`	Specifies whether to create a new Sql tuning set or not.
`SqlTuningSetAdminCredentialDetails`	`getCredentialDetails()`
`DatabaseCredentialDetails`	`getDatabaseCredential()`
`String`	`getDestinationSqlTuningSetDescription()`	The description for the destination Sql tuning set.
`String`	`getDestinationSqlTuningSetName()`	The name of the destination Sql tuning set.
`String`	`getDestinationSqlTuningSetOwner()`	Owner of the destination Sql tuning set.
`Boolean`	`getIsIgnoreNull()`	Specifies whether to update attributes when the new value is NULL.
`SaveSqlTuningSetAsDetails.LoadOption`	`getLoadOption()`	Specifies which statements are loaded into the Sql tuning set.
`String`	`getName()`	The name of the Sql tuning set.
`String`	`getOwner()`	The owner of the Sql tuning set.
`SaveSqlTuningSetAsDetails.PlanFilter`	`getPlanFilter()`	Specifies the plan filter.
`RankingMeasure`	`getRankingMeasure1()`	Specifies an ORDER BY clause on the selected Sql.
`RankingMeasure`	`getRankingMeasure2()`	Specifies an ORDER BY clause on the selected Sql.
`RankingMeasure`	`getRankingMeasure3()`	Specifies an ORDER BY clause on the selected Sql.
`SaveSqlTuningSetAsDetails.RecursiveSql`	`getRecursiveSql()`	Specifies that the filter must include recursive Sql in the Sql tuning set.
`Integer`	`getResultLimit()`	The top limit Sql from the filtered source, ranked by the ranking measure.
`Double`	`getResultPercentage()`	Specifies a filter that picks the top n% according to the supplied ranking measure.
`Integer`	`getShowSqlOnly()`	Flag to indicate whether to save the Sql tuning set or just display the plsql used to save Sql tuning set.
`String`	`getUpdateAttributes()`	Specifies the list of Sql statement attributes to update during a merge or update.
`SaveSqlTuningSetAsDetails.UpdateCondition`	`getUpdateCondition()`	Specifies when to perform the update.
`SaveSqlTuningSetAsDetails.UpdateOption`	`getUpdateOption()`	Specifies how existing Sql statements are updated.
`int`	`hashCode()`
`SaveSqlTuningSetAsDetails.Builder`	`toBuilder()`
`String`	`toString()`
`String`	`toString(boolean includeByteArrayContents)`	Return a string representation of the object.

Methods inherited from class com.oracle.bmc.http.client.internal.ExplicitlySetBmcModel
markPropertyAsExplicitlySet, wasPropertyExplicitlySet

Methods inherited from class java.lang.Object
clone, finalize, getClass, notify, notifyAll, wait, wait, wait

- Constructor Detail
  - SaveSqlTuningSetAsDetails
```
@Deprecated
@ConstructorProperties({"credentialDetails","databaseCredential","showSqlOnly","owner","name","destinationSqlTuningSetName","destinationSqlTuningSetDescription","destinationSqlTuningSetOwner","createNew","basicFilter","planFilter","recursiveSql","resultPercentage","resultLimit","rankingMeasure1","rankingMeasure2","rankingMeasure3","attributeList","loadOption","updateOption","updateCondition","updateAttributes","isIgnoreNull","commitRows"})
public SaveSqlTuningSetAsDetails(SqlTuningSetAdminCredentialDetails credentialDetails,
                                 DatabaseCredentialDetails databaseCredential,
                                 Integer showSqlOnly,
                                 String owner,
                                 String name,
                                 String destinationSqlTuningSetName,
                                 String destinationSqlTuningSetDescription,
                                 String destinationSqlTuningSetOwner,
                                 Integer createNew,
                                 String basicFilter,
                                 SaveSqlTuningSetAsDetails.PlanFilter planFilter,
                                 SaveSqlTuningSetAsDetails.RecursiveSql recursiveSql,
                                 Double resultPercentage,
                                 Integer resultLimit,
                                 RankingMeasure rankingMeasure1,
                                 RankingMeasure rankingMeasure2,
                                 RankingMeasure rankingMeasure3,
                                 String attributeList,
                                 SaveSqlTuningSetAsDetails.LoadOption loadOption,
                                 SaveSqlTuningSetAsDetails.UpdateOption updateOption,
                                 SaveSqlTuningSetAsDetails.UpdateCondition updateCondition,
                                 String updateAttributes,
                                 Boolean isIgnoreNull,
                                 Integer commitRows)
```
    Deprecated.
- Method Detail
  - builder
```
public static SaveSqlTuningSetAsDetails.Builder builder()
```
    Create a new builder.
  - toBuilder
```
public SaveSqlTuningSetAsDetails.Builder toBuilder()
```
  - getCredentialDetails
```
public SqlTuningSetAdminCredentialDetails getCredentialDetails()
```
  - getDatabaseCredential
```
public DatabaseCredentialDetails getDatabaseCredential()
```
  - getShowSqlOnly
```
public Integer getShowSqlOnly()
```
    Flag to indicate whether to save the Sql tuning set or just display the plsql used to save Sql tuning set.
    
    Returns:
    
    the value
  - getOwner
```
public String getOwner()
```
    The owner of the Sql tuning set.
    
    Returns:
    
    the value
  - getName
```
public String getName()
```
    The name of the Sql tuning set.
    
    Returns:
    
    the value
  - getDestinationSqlTuningSetName
```
public String getDestinationSqlTuningSetName()
```
    The name of the destination Sql tuning set.
    
    Returns:
    
    the value
  - getDestinationSqlTuningSetDescription
```
public String getDestinationSqlTuningSetDescription()
```
    The description for the destination Sql tuning set.
    
    Returns:
    
    the value
  - getDestinationSqlTuningSetOwner
```
public String getDestinationSqlTuningSetOwner()
```
    Owner of the destination Sql tuning set.
    
    Returns:
    
    the value
  - getCreateNew
```
public Integer getCreateNew()
```
    Specifies whether to create a new Sql tuning set or not.
    Possible values 1 - Create a new Sql tuning set 0 - Do not create a new Sql tuning set
    
    Returns:
    
    the value
  - getBasicFilter
```
public String getBasicFilter()
```
    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
    
    Returns:
    
    the value
  - getPlanFilter
```
public SaveSqlTuningSetAsDetails.PlanFilter getPlanFilter()
```
    Specifies the plan filter.
    This parameter enables you to select a single plan when a statement has multiple plans. Refer to the documentation https://docs.oracle.com/en/database/oracle/oracle-database/19/arpls/DBMS_SQLSET.html#GUID-9D995019-91AB-4B1E-9EAF-031050789B21
    
    Returns:
    
    the value
  - getRecursiveSql
```
public SaveSqlTuningSetAsDetails.RecursiveSql getRecursiveSql()
```
    Specifies that the filter must include recursive Sql in the Sql tuning set.
    
    Returns:
    
    the value
  - getResultPercentage
```
public Double getResultPercentage()
```
    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.
    
    Returns:
    
    the value
  - getResultLimit
```
public Integer getResultLimit()
```
    The top limit Sql from the filtered source, ranked by the ranking measure.
    
    Returns:
    
    the value
  - getRankingMeasure1
```
public RankingMeasure getRankingMeasure1()
```
    Specifies an ORDER BY clause on the selected Sql.
    User can specify upto three ranking measures.
    
    Returns:
    
    the value
  - getRankingMeasure2
```
public RankingMeasure getRankingMeasure2()
```
    Specifies an ORDER BY clause on the selected Sql.
    User can specify upto three ranking measures.
    
    Returns:
    
    the value
  - getRankingMeasure3
```
public RankingMeasure getRankingMeasure3()
```
    Specifies an ORDER BY clause on the selected Sql.
    User can specify upto three ranking measures.
    
    Returns:
    
    the value
  - getAttributeList
```
public String getAttributeList()
```
    Specifies the list of Sql statement attributes to return in the result.
    Note that this parameter cannot be made an enum since custom value can take a list of comma separated attribute names. Attribute list can take one of the following values. TYPICAL - Specifies BASIC plus Sql plan (without row source statistics) and without object reference list (default). BASIC - Specifies all attributes (such as execution statistics and binds) except the plans. The execution context is always part of the result. ALL - Specifies all attributes. CUSTOM - Comma-separated list of the following attribute names. - EXECUTION_STATISTICS - BIND_LIST - OBJECT_LIST - SQL_PLAN - SQL_PLAN_STATISTICS Usage examples: 1. “attributeList”: “TYPICAL” 2. “attributeList”: “ALL” 3. “attributeList”: “EXECUTION_STATISTICS,OBJECT_LIST,SQL_PLAN”
    
    Returns:
    
    the value
  - getLoadOption
```
public SaveSqlTuningSetAsDetails.LoadOption getLoadOption()
```
    Specifies which statements are loaded into the Sql tuning set.
    The possible values are. - INSERT (default) Adds only new statements. - UPDATE Updates existing the Sql statements and ignores any new statements. - MERGE Inserts new statements and updates the information of the existing ones.
    
    Returns:
    
    the value
  - getUpdateOption
```
public SaveSqlTuningSetAsDetails.UpdateOption getUpdateOption()
```
    Specifies how existing Sql statements are updated.
    This parameter is applicable only if load_option is specified with UPDATE or MERGE as an option. Update option can take one of the following values. REPLACE (default) - Updates the statement using the new statistics, bind list, object list, and so on. ACCUMULATE - Combines attributes when possible (for example, statistics such as elapsed_time), otherwise replaces the existing values (for example, module and action) with the provided values. Following Sql statement attributes can be accumulated. elapsed_time buffer_gets direct_writes disk_reads row_processed fetches executions end_of_fetch_count stat_period active_stat_period
    
    Returns:
    
    the value
  - getUpdateCondition
```
public SaveSqlTuningSetAsDetails.UpdateCondition getUpdateCondition()
```
    Specifies when to perform the update.
    The procedure only performs the update when the specified condition is satisfied. The condition can refer to either the data source or destination. The condition must use the following prefixes to refer to attributes from the source or the destination: OLD \u2014 Refers to statement attributes from the SQL tuning set (destination). NEW \u2014 Refers to statement attributes from the input statements (source). NULL \u2014 No updates are performed.
    
    Returns:
    
    the value
  - getUpdateAttributes
```
public String getUpdateAttributes()
```
    Specifies the list of Sql statement attributes to update during a merge or update.
    Note that this parameter cannot be made an enum since custom value can take a list of comma separated attribute names. Update attributes can take one of the following values. NULL (default) - Specifies the content of the input cursor except the execution context. On other terms, it is equivalent to ALL without execution contexts such as module and action. BASIC - Specifies statistics and binds only. TYPICAL - Specifies BASIC with Sql plans (without row source statistics) and without an object reference list. ALL - Specifies all attributes, including the execution context attributes such as module and action. CUSTOM - List of comma separated attribute names to update EXECUTION_CONTEXT EXECUTION_STATISTICS SQL_BINDS SQL_PLAN SQL_PLAN_STATISTICS (similar to SQL_PLAN with added row source statistics) Usage examples: 1. “updateAttributes”: “TYPICAL” 2. “updateAttributes”: “BASIC” 3. “updateAttributes”: “EXECUTION_STATISTICS,SQL_PLAN_STATISTICS,SQL_PLAN” 4. “updateAttributes”: “EXECUTION_STATISTICS,SQL_PLAN”
    
    Returns:
    
    the value
  - getIsIgnoreNull
```
public Boolean getIsIgnoreNull()
```
    Specifies whether to update attributes when the new value is NULL.
    If TRUE, then the procedure does not update an attribute when the new value is NULL. That is, do not override with NULL values unless intentional. Possible values - true or false
    
    Returns:
    
    the value
  - getCommitRows
```
public Integer getCommitRows()
```
    Specifies whether to commit statements after DML.
    If a value is provided, then the load commits after each specified number of statements is inserted. If NULL is provided, then the load commits only once, at the end of the operation.
    
    Returns:
    
    the value
  - toString
```
public String toString()
```
    Overrides:
    
    toString in class com.oracle.bmc.http.client.internal.ExplicitlySetBmcModel
  - toString
```
public String toString(boolean includeByteArrayContents)
```
    Return a string representation of the object.
    
    Parameters:
    
    includeByteArrayContents - true to include the full contents of byte arrays
    
    Returns:
    
    string representation
  - equals
```
public boolean equals(Object o)
```
    Overrides:
    
    equals in class com.oracle.bmc.http.client.internal.ExplicitlySetBmcModel
  - hashCode
```
public int hashCode()
```
    Overrides:
    
    hashCode in class com.oracle.bmc.http.client.internal.ExplicitlySetBmcModel

Class SaveSqlTuningSetAsDetails

Nested Class Summary

Field Summary

Fields inherited from class com.oracle.bmc.http.client.internal.ExplicitlySetBmcModel

Constructor Summary

Method Summary

Methods inherited from class com.oracle.bmc.http.client.internal.ExplicitlySetBmcModel

Methods inherited from class java.lang.Object

Constructor Detail

SaveSqlTuningSetAsDetails

Method Detail

builder

toBuilder

getCredentialDetails

getDatabaseCredential

getShowSqlOnly

getOwner

getName

getDestinationSqlTuningSetName

getDestinationSqlTuningSetDescription

getDestinationSqlTuningSetOwner

getCreateNew

getBasicFilter

getPlanFilter

getRecursiveSql

getResultPercentage

getResultLimit

getRankingMeasure1

getRankingMeasure2

getRankingMeasure3

getAttributeList

getLoadOption

getUpdateOption

getUpdateCondition

getUpdateAttributes

getIsIgnoreNull

getCommitRows

toString

toString

equals

hashCode