Package com.oracle.bmc.databasemanagement.model

Class SqlTuningAdvisorTaskFindingSummary

  • @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).

    • Constructor Detail

      • SqlTuningAdvisorTaskFindingSummary

        @Deprecated
@ConstructorProperties({"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)
        Deprecated.

    • Method Detail

      • getSqlTuningAdvisorTaskId

        public Long getSqlTuningAdvisorTaskId()
        The unique identifier of the SQL Tuning Advisor task.

        This is not the OCID.

        Returns:
        the value

      • getSqlTuningAdvisorTaskObjectId

        public Long getSqlTuningAdvisorTaskObjectId()
        The key of the object to which these recommendations apply.

        This is not the OCID.

        Returns:
        the value

      • getSqlTuningAdvisorTaskObjectExecutionId

        public Long getSqlTuningAdvisorTaskObjectExecutionId()
        The execution id of the analyzed SQL object.

        This is not the OCID.

        Returns:
        the value

      • getSqlText

        public String getSqlText()
        The text of the SQL statement.
        Returns:
        the value

      • getParsingSchema

        public String getParsingSchema()
        The parsing schema of the object.
        Returns:
        the value

      • getSqlKey

        public String getSqlKey()
        The unique key of this SQL statement.
        Returns:
        the value

      • getDbTimeBenefit

        public Float getDbTimeBenefit()
        The time benefit (in seconds) for the highest-rated finding for this object.
        Returns:
        the value

      • getPerExecutionPercentage

        public Integer getPerExecutionPercentage()
        The per-execution percentage benefit.
        Returns:
        the value

      • getIsStatsFindingPresent

        public Boolean getIsStatsFindingPresent()
        Indicates whether a statistics recommendation was reported for this SQL statement.
        Returns:
        the value

      • getIsSqlProfileFindingPresent

        public Boolean getIsSqlProfileFindingPresent()
        Indicates whether a SQL Profile recommendation was reported for this SQL statement.
        Returns:
        the value

      • getIsSqlProfileFindingImplemented

        public Boolean getIsSqlProfileFindingImplemented()
        Indicates whether a SQL Profile recommendation has been implemented for this SQL statement.
        Returns:
        the value

      • getIsIndexFindingPresent

        public Boolean getIsIndexFindingPresent()
        Indicates whether an index recommendation was reported for this SQL statement.
        Returns:
        the value

      • getIsRestructureSqlFindingPresent

        public Boolean getIsRestructureSqlFindingPresent()
        Indicates whether a restructure SQL recommendation was reported for this SQL statement.
        Returns:
        the value

      • getIsAlternativePlanFindingPresent

        public Boolean getIsAlternativePlanFindingPresent()
        Indicates whether an alternative execution plan was reported for this SQL statement.
        Returns:
        the value

      • getIsMiscellaneousFindingPresent

        public Boolean getIsMiscellaneousFindingPresent()
        Indicates whether a miscellaneous finding was reported for this SQL statement.
        Returns:
        the value

      • getIsErrorFindingPresent

        public Boolean getIsErrorFindingPresent()
        Indicates whether there is an error in this SQL statement.
        Returns:
        the value

      • getIsTimeoutFindingPresent

        public Boolean getIsTimeoutFindingPresent()
        Indicates whether the task timed out.
        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