Package com.oracle.bmc.databasemanagement.model

Class SqlPlanBaseline.Builder

    • Constructor Detail

      • Builder

        public Builder()

    • Method Detail

      • planName

        public SqlPlanBaseline.Builder planName​(String planName)
        The unique plan identifier.
        Parameters:
        planName - the value to set
        Returns:
        this builder

      • sqlHandle

        public SqlPlanBaseline.Builder sqlHandle​(String sqlHandle)
        The unique SQL identifier.
        Parameters:
        sqlHandle - the value to set
        Returns:
        this builder

      • sqlText

        public SqlPlanBaseline.Builder sqlText​(String sqlText)
        The SQL text.
        Parameters:
        sqlText - the value to set
        Returns:
        this builder

      • timeCreated

        public SqlPlanBaseline.Builder timeCreated​(Date timeCreated)
        The date and time when the plan baseline was created.
        Parameters:
        timeCreated - the value to set
        Returns:
        this builder

      • timeLastModified

        public SqlPlanBaseline.Builder timeLastModified​(Date timeLastModified)
        The date and time when the plan baseline was last modified.
        Parameters:
        timeLastModified - the value to set
        Returns:
        this builder

      • timeLastExecuted

        public SqlPlanBaseline.Builder timeLastExecuted​(Date timeLastExecuted)
        The date and time when the plan baseline was last executed.

        *Note:** For performance reasons, database does not update this value immediately after each execution of the plan baseline. Therefore, the plan baseline may have been executed more recently than this value indicates.

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

      • reproduced

        public SqlPlanBaseline.Builder reproduced​(SqlPlanBaseline.Reproduced reproduced)
        Indicates whether the optimizer was able to reproduce the plan (YES) or not (NO).

        The value is set to YES when a plan is initially added to the plan baseline.

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

      • adaptive

        public SqlPlanBaseline.Builder adaptive​(SqlPlanBaseline.Adaptive adaptive)
        Indicates whether a plan that is automatically captured by SQL plan management is marked adaptive or not.

        When a new adaptive plan is found for a SQL statement that has an existing SQL plan baseline, that new plan will be added to the SQL plan baseline as an unaccepted plan, and the ADAPTIVE property will be marked YES. When this new plan is verified (either manually or via the auto evolve task), the plan will be test executed and the final plan determined at execution will become an accepted plan if its performance is better than the existing plan baseline. At this point, the value of the ADAPTIVE property is set to NO since the plan is no longer adaptive, but resolved.

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

      • module

        public SqlPlanBaseline.Builder module​(String module)
        The application module name.
        Parameters:
        module - the value to set
        Returns:
        this builder

      • action

        public SqlPlanBaseline.Builder action​(String action)
        The application action.
        Parameters:
        action - the value to set
        Returns:
        this builder

      • executionPlan

        public SqlPlanBaseline.Builder executionPlan​(String executionPlan)
        The execution plan for the SQL statement.
        Parameters:
        executionPlan - the value to set
        Returns:
        this builder