Package com.oracle.bmc.databasemanagement.model

Class SaveSqlTuningSetAsDetails.Builder

    • Constructor Detail

      • Builder

        public Builder()

    • Method Detail

      • showSqlOnly

        public SaveSqlTuningSetAsDetails.Builder showSqlOnly​(Integer showSqlOnly)
        Flag to indicate whether to save the Sql tuning set or just display the plsql used to save Sql tuning set.
        Parameters:
        showSqlOnly - the value to set
        Returns:
        this builder

      • destinationSqlTuningSetName

        public SaveSqlTuningSetAsDetails.Builder destinationSqlTuningSetName​(String destinationSqlTuningSetName)
        The name of the destination Sql tuning set.
        Parameters:
        destinationSqlTuningSetName - the value to set
        Returns:
        this builder

      • destinationSqlTuningSetDescription

        public SaveSqlTuningSetAsDetails.Builder destinationSqlTuningSetDescription​(String destinationSqlTuningSetDescription)
        The description for the destination Sql tuning set.
        Parameters:
        destinationSqlTuningSetDescription - the value to set
        Returns:
        this builder

      • destinationSqlTuningSetOwner

        public SaveSqlTuningSetAsDetails.Builder destinationSqlTuningSetOwner​(String destinationSqlTuningSetOwner)
        Owner of the destination Sql tuning set.
        Parameters:
        destinationSqlTuningSetOwner - the value to set
        Returns:
        this builder

      • createNew

        public SaveSqlTuningSetAsDetails.Builder createNew​(Integer createNew)
        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

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

      • basicFilter

        public SaveSqlTuningSetAsDetails.Builder basicFilter​(String basicFilter)
        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

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

      • planFilter

        public SaveSqlTuningSetAsDetails.Builder planFilter​(SaveSqlTuningSetAsDetails.PlanFilter planFilter)
        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

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

      • resultPercentage

        public SaveSqlTuningSetAsDetails.Builder resultPercentage​(Double resultPercentage)
        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.

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

      • resultLimit

        public SaveSqlTuningSetAsDetails.Builder resultLimit​(Integer resultLimit)
        The top limit Sql from the filtered source, ranked by the ranking measure.
        Parameters:
        resultLimit - the value to set
        Returns:
        this builder

      • rankingMeasure1

        public SaveSqlTuningSetAsDetails.Builder rankingMeasure1​(RankingMeasure rankingMeasure1)
        Specifies an ORDER BY clause on the selected Sql.

        User can specify upto three ranking measures.

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

      • rankingMeasure2

        public SaveSqlTuningSetAsDetails.Builder rankingMeasure2​(RankingMeasure rankingMeasure2)
        Specifies an ORDER BY clause on the selected Sql.

        User can specify upto three ranking measures.

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

      • rankingMeasure3

        public SaveSqlTuningSetAsDetails.Builder rankingMeasure3​(RankingMeasure rankingMeasure3)
        Specifies an ORDER BY clause on the selected Sql.

        User can specify upto three ranking measures.

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

      • attributeList

        public SaveSqlTuningSetAsDetails.Builder attributeList​(String attributeList)
        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”

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

      • loadOption

        public SaveSqlTuningSetAsDetails.Builder loadOption​(SaveSqlTuningSetAsDetails.LoadOption loadOption)
        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.

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

      • updateOption

        public SaveSqlTuningSetAsDetails.Builder updateOption​(SaveSqlTuningSetAsDetails.UpdateOption updateOption)
        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

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

      • updateCondition

        public SaveSqlTuningSetAsDetails.Builder updateCondition​(SaveSqlTuningSetAsDetails.UpdateCondition updateCondition)
        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.

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

      • updateAttributes

        public SaveSqlTuningSetAsDetails.Builder updateAttributes​(String updateAttributes)
        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”

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

      • isIgnoreNull

        public SaveSqlTuningSetAsDetails.Builder isIgnoreNull​(Boolean isIgnoreNull)
        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

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

      • commitRows

        public SaveSqlTuningSetAsDetails.Builder commitRows​(Integer commitRows)
        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.

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