@Generated(value="OracleSDKGenerator", comments="API Version: 20201101") public final class SqlTuningAdvisorTaskFindingSummary extends com.oracle.bmc.http.client.internal.ExplicitlySetBmcModel
A summary of the findings of the objects in a tuning task that match a given filter. This
includes the kind of findings that were reported, whether the benefits were analyzed, and the
number of benefits obtained.
Note: Objects should always be created or deserialized using the SqlTuningAdvisorTaskFindingSummary.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 SqlTuningAdvisorTaskFindingSummary.Builder
, which maintain a
set of all explicitly set fields called SqlTuningAdvisorTaskFindingSummary.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
).
Modifier and Type | Class and Description |
---|---|
static class |
SqlTuningAdvisorTaskFindingSummary.Builder |
EXPLICITLY_SET_FILTER_NAME, EXPLICITLY_SET_PROPERTY_NAME
Constructor and Description |
---|
SqlTuningAdvisorTaskFindingSummary(Long sqlTuningAdvisorTaskId,
Long sqlTuningAdvisorTaskObjectId,
Long sqlTuningAdvisorTaskObjectExecutionId,
String sqlText,
String parsingSchema,
String sqlKey,
Float dbTimeBenefit,
Integer perExecutionPercentage,
Boolean isStatsFindingPresent,
Boolean isSqlProfileFindingPresent,
Boolean isSqlProfileFindingImplemented,
Boolean isIndexFindingPresent,
Boolean isRestructureSqlFindingPresent,
Boolean isAlternativePlanFindingPresent,
Boolean isMiscellaneousFindingPresent,
Boolean isErrorFindingPresent,
Boolean isTimeoutFindingPresent)
Deprecated.
|
Modifier and Type | Method and Description |
---|---|
static SqlTuningAdvisorTaskFindingSummary.Builder |
builder()
Create a new builder.
|
boolean |
equals(Object o) |
Float |
getDbTimeBenefit()
The time benefit (in seconds) for the highest-rated finding for this object.
|
Boolean |
getIsAlternativePlanFindingPresent()
Indicates whether an alternative execution plan was reported for this SQL statement.
|
Boolean |
getIsErrorFindingPresent()
Indicates whether there is an error in this SQL statement.
|
Boolean |
getIsIndexFindingPresent()
Indicates whether an index recommendation was reported for this SQL statement.
|
Boolean |
getIsMiscellaneousFindingPresent()
Indicates whether a miscellaneous finding was reported for this SQL statement.
|
Boolean |
getIsRestructureSqlFindingPresent()
Indicates whether a restructure SQL recommendation was reported for this SQL statement.
|
Boolean |
getIsSqlProfileFindingImplemented()
Indicates whether a SQL Profile recommendation has been implemented for this SQL statement.
|
Boolean |
getIsSqlProfileFindingPresent()
Indicates whether a SQL Profile recommendation was reported for this SQL statement.
|
Boolean |
getIsStatsFindingPresent()
Indicates whether a statistics recommendation was reported for this SQL statement.
|
Boolean |
getIsTimeoutFindingPresent()
Indicates whether the task timed out.
|
String |
getParsingSchema()
The parsing schema of the object.
|
Integer |
getPerExecutionPercentage()
The per-execution percentage benefit.
|
String |
getSqlKey()
The unique key of this SQL statement.
|
String |
getSqlText()
The text of the SQL statement.
|
Long |
getSqlTuningAdvisorTaskId()
The unique identifier of the SQL Tuning Advisor task.
|
Long |
getSqlTuningAdvisorTaskObjectExecutionId()
The execution id of the analyzed SQL object.
|
Long |
getSqlTuningAdvisorTaskObjectId()
The key of the object to which these recommendations apply.
|
int |
hashCode() |
SqlTuningAdvisorTaskFindingSummary.Builder |
toBuilder() |
String |
toString() |
String |
toString(boolean includeByteArrayContents)
Return a string representation of the object.
|
markPropertyAsExplicitlySet, wasPropertyExplicitlySet
@Deprecated @ConstructorProperties(value={"sqlTuningAdvisorTaskId","sqlTuningAdvisorTaskObjectId","sqlTuningAdvisorTaskObjectExecutionId","sqlText","parsingSchema","sqlKey","dbTimeBenefit","perExecutionPercentage","isStatsFindingPresent","isSqlProfileFindingPresent","isSqlProfileFindingImplemented","isIndexFindingPresent","isRestructureSqlFindingPresent","isAlternativePlanFindingPresent","isMiscellaneousFindingPresent","isErrorFindingPresent","isTimeoutFindingPresent"}) public SqlTuningAdvisorTaskFindingSummary(Long sqlTuningAdvisorTaskId, Long sqlTuningAdvisorTaskObjectId, Long sqlTuningAdvisorTaskObjectExecutionId, String sqlText, String parsingSchema, String sqlKey, Float dbTimeBenefit, Integer perExecutionPercentage, Boolean isStatsFindingPresent, Boolean isSqlProfileFindingPresent, Boolean isSqlProfileFindingImplemented, Boolean isIndexFindingPresent, Boolean isRestructureSqlFindingPresent, Boolean isAlternativePlanFindingPresent, Boolean isMiscellaneousFindingPresent, Boolean isErrorFindingPresent, Boolean isTimeoutFindingPresent)
public static SqlTuningAdvisorTaskFindingSummary.Builder builder()
Create a new builder.
public SqlTuningAdvisorTaskFindingSummary.Builder toBuilder()
public Long getSqlTuningAdvisorTaskId()
The unique identifier of the SQL Tuning Advisor task. This is not the OCID.
public Long getSqlTuningAdvisorTaskObjectId()
The key of the object to which these recommendations apply. This is not the OCID.
public Long getSqlTuningAdvisorTaskObjectExecutionId()
The execution id of the analyzed SQL object. This is not the OCID.
public String getSqlText()
The text of the SQL statement.
public String getParsingSchema()
The parsing schema of the object.
public String getSqlKey()
The unique key of this SQL statement.
public Float getDbTimeBenefit()
The time benefit (in seconds) for the highest-rated finding for this object.
public Integer getPerExecutionPercentage()
The per-execution percentage benefit.
public Boolean getIsStatsFindingPresent()
Indicates whether a statistics recommendation was reported for this SQL statement.
public Boolean getIsSqlProfileFindingPresent()
Indicates whether a SQL Profile recommendation was reported for this SQL statement.
public Boolean getIsSqlProfileFindingImplemented()
Indicates whether a SQL Profile recommendation has been implemented for this SQL statement.
public Boolean getIsIndexFindingPresent()
Indicates whether an index recommendation was reported for this SQL statement.
public Boolean getIsRestructureSqlFindingPresent()
Indicates whether a restructure SQL recommendation was reported for this SQL statement.
public Boolean getIsAlternativePlanFindingPresent()
Indicates whether an alternative execution plan was reported for this SQL statement.
public Boolean getIsMiscellaneousFindingPresent()
Indicates whether a miscellaneous finding was reported for this SQL statement.
public Boolean getIsErrorFindingPresent()
Indicates whether there is an error in this SQL statement.
public Boolean getIsTimeoutFindingPresent()
Indicates whether the task timed out.
public String toString()
toString
in class com.oracle.bmc.http.client.internal.ExplicitlySetBmcModel
public String toString(boolean includeByteArrayContents)
Return a string representation of the object.
includeByteArrayContents
- true to include the full contents of byte arrayspublic boolean equals(Object o)
equals
in class com.oracle.bmc.http.client.internal.ExplicitlySetBmcModel
public int hashCode()
hashCode
in class com.oracle.bmc.http.client.internal.ExplicitlySetBmcModel
Copyright © 2016–2025. All rights reserved.