Package com.oracle.bmc.databasemanagement.model

Class SqlTuningAdvisorTaskFindingSummary.Builder

    • Constructor Detail

      • Builder

        public Builder()

    • Method Detail

      • sqlTuningAdvisorTaskId

        public SqlTuningAdvisorTaskFindingSummary.Builder sqlTuningAdvisorTaskId​(Long sqlTuningAdvisorTaskId)
        The unique identifier of the SQL Tuning Advisor task.

        This is not the OCID.

        Parameters:
        sqlTuningAdvisorTaskId - the value to set
        Returns:
        this builder

      • sqlTuningAdvisorTaskObjectId

        public SqlTuningAdvisorTaskFindingSummary.Builder sqlTuningAdvisorTaskObjectId​(Long sqlTuningAdvisorTaskObjectId)
        The key of the object to which these recommendations apply.

        This is not the OCID.

        Parameters:
        sqlTuningAdvisorTaskObjectId - the value to set
        Returns:
        this builder

      • sqlTuningAdvisorTaskObjectExecutionId

        public SqlTuningAdvisorTaskFindingSummary.Builder sqlTuningAdvisorTaskObjectExecutionId​(Long sqlTuningAdvisorTaskObjectExecutionId)
        The execution id of the analyzed SQL object.

        This is not the OCID.

        Parameters:
        sqlTuningAdvisorTaskObjectExecutionId - the value to set
        Returns:
        this builder

      • dbTimeBenefit

        public SqlTuningAdvisorTaskFindingSummary.Builder dbTimeBenefit​(Float dbTimeBenefit)
        The time benefit (in seconds) for the highest-rated finding for this object.
        Parameters:
        dbTimeBenefit - the value to set
        Returns:
        this builder

      • perExecutionPercentage

        public SqlTuningAdvisorTaskFindingSummary.Builder perExecutionPercentage​(Integer perExecutionPercentage)
        The per-execution percentage benefit.
        Parameters:
        perExecutionPercentage - the value to set
        Returns:
        this builder

      • isStatsFindingPresent

        public SqlTuningAdvisorTaskFindingSummary.Builder isStatsFindingPresent​(Boolean isStatsFindingPresent)
        Indicates whether a statistics recommendation was reported for this SQL statement.
        Parameters:
        isStatsFindingPresent - the value to set
        Returns:
        this builder

      • isSqlProfileFindingPresent

        public SqlTuningAdvisorTaskFindingSummary.Builder isSqlProfileFindingPresent​(Boolean isSqlProfileFindingPresent)
        Indicates whether a SQL Profile recommendation was reported for this SQL statement.
        Parameters:
        isSqlProfileFindingPresent - the value to set
        Returns:
        this builder

      • isSqlProfileFindingImplemented

        public SqlTuningAdvisorTaskFindingSummary.Builder isSqlProfileFindingImplemented​(Boolean isSqlProfileFindingImplemented)
        Indicates whether a SQL Profile recommendation has been implemented for this SQL statement.
        Parameters:
        isSqlProfileFindingImplemented - the value to set
        Returns:
        this builder

      • isIndexFindingPresent

        public SqlTuningAdvisorTaskFindingSummary.Builder isIndexFindingPresent​(Boolean isIndexFindingPresent)
        Indicates whether an index recommendation was reported for this SQL statement.
        Parameters:
        isIndexFindingPresent - the value to set
        Returns:
        this builder

      • isRestructureSqlFindingPresent

        public SqlTuningAdvisorTaskFindingSummary.Builder isRestructureSqlFindingPresent​(Boolean isRestructureSqlFindingPresent)
        Indicates whether a restructure SQL recommendation was reported for this SQL statement.
        Parameters:
        isRestructureSqlFindingPresent - the value to set
        Returns:
        this builder

      • isAlternativePlanFindingPresent

        public SqlTuningAdvisorTaskFindingSummary.Builder isAlternativePlanFindingPresent​(Boolean isAlternativePlanFindingPresent)
        Indicates whether an alternative execution plan was reported for this SQL statement.
        Parameters:
        isAlternativePlanFindingPresent - the value to set
        Returns:
        this builder

      • isMiscellaneousFindingPresent

        public SqlTuningAdvisorTaskFindingSummary.Builder isMiscellaneousFindingPresent​(Boolean isMiscellaneousFindingPresent)
        Indicates whether a miscellaneous finding was reported for this SQL statement.
        Parameters:
        isMiscellaneousFindingPresent - the value to set
        Returns:
        this builder

      • isErrorFindingPresent

        public SqlTuningAdvisorTaskFindingSummary.Builder isErrorFindingPresent​(Boolean isErrorFindingPresent)
        Indicates whether there is an error in this SQL statement.
        Parameters:
        isErrorFindingPresent - the value to set
        Returns:
        this builder

      • isTimeoutFindingPresent

        public SqlTuningAdvisorTaskFindingSummary.Builder isTimeoutFindingPresent​(Boolean isTimeoutFindingPresent)
        Indicates whether the task timed out.
        Parameters:
        isTimeoutFindingPresent - the value to set
        Returns:
        this builder