Package com.oracle.bmc.databasemanagement.model

Class FetchSqlTuningSetDetails

java.lang.Object

com.oracle.bmc.http.client.internal.ExplicitlySetBmcModel

com.oracle.bmc.databasemanagement.model.FetchSqlTuningSetDetails

@Generated(value="OracleSDKGenerator",
           comments="API Version: 20201101")
public final class FetchSqlTuningSetDetails
extends com.oracle.bmc.http.client.internal.ExplicitlySetBmcModel

The details required to fetch the Sql tuning set details.

It takes either credentialDetails or databaseCredential. It’s recommended to provide databaseCredential
Note: Objects should always be created or deserialized using the FetchSqlTuningSetDetails.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 FetchSqlTuningSetDetails.Builder, which maintain a set of all explicitly set fields called FetchSqlTuningSetDetails.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	FetchSqlTuningSetDetails.Builder
static class	FetchSqlTuningSetDetails.RecursiveSql	Specifies that the filter must include recursive Sql in the Sql tuning set.

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
FetchSqlTuningSetDetails(SqlTuningSetAdminCredentialDetails credentialDetails, DatabaseCredentialDetails databaseCredential, String owner, String name, String basicFilter, FetchSqlTuningSetDetails.RecursiveSql recursiveSql, Double resultPercentage, Integer resultLimit, RankingMeasure rankingMeasure1, RankingMeasure rankingMeasure2, RankingMeasure rankingMeasure3)	Deprecated.

Method Summary

Modifier and Type	Method	Description
static FetchSqlTuningSetDetails.Builder	builder()	Create a new builder.
boolean	equals(Object o)
String	getBasicFilter()	Specifies the Sql predicate to filter the Sql from the Sql tuning set defined on attributes of the SQLSET_ROW.
SqlTuningSetAdminCredentialDetails	getCredentialDetails()
DatabaseCredentialDetails	getDatabaseCredential()
String	getName()	The name of the Sql tuning set.
String	getOwner()	The owner of the Sql tuning set.
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.
FetchSqlTuningSetDetails.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.
int	hashCode()
FetchSqlTuningSetDetails.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

FetchSqlTuningSetDetails

@Deprecated
@ConstructorProperties({"credentialDetails","databaseCredential","owner","name","basicFilter","recursiveSql","resultPercentage","resultLimit","rankingMeasure1","rankingMeasure2","rankingMeasure3"})
public FetchSqlTuningSetDetails(SqlTuningSetAdminCredentialDetails credentialDetails,
                                DatabaseCredentialDetails databaseCredential,
                                String owner,
                                String name,
                                String basicFilter,
                                FetchSqlTuningSetDetails.RecursiveSql recursiveSql,
                                Double resultPercentage,
                                Integer resultLimit,
                                RankingMeasure rankingMeasure1,
                                RankingMeasure rankingMeasure2,
                                RankingMeasure rankingMeasure3)

Deprecated.

Method Detail

builder

public static FetchSqlTuningSetDetails.Builder builder()

Create a new builder.

toBuilder

public FetchSqlTuningSetDetails.Builder toBuilder()

getCredentialDetails

public SqlTuningSetAdminCredentialDetails getCredentialDetails()

getDatabaseCredential

public DatabaseCredentialDetails getDatabaseCredential()

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

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

getRecursiveSql

public FetchSqlTuningSetDetails.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

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