Package com.oracle.bmc.databasemanagement.requests

Class ListSqlPlanBaselinesRequest.Builder

    • Constructor Detail

      • Builder

        public Builder()

    • Method Detail

      • managedDatabaseId

        public ListSqlPlanBaselinesRequest.Builder managedDatabaseId​(String managedDatabaseId)
        The OCID of the Managed Database.
        Parameters:
        managedDatabaseId - the value to set
        Returns:
        this builder instance

      • planName

        public ListSqlPlanBaselinesRequest.Builder planName​(String planName)
        A filter to return only SQL plan baselines that match the plan name.
        Parameters:
        planName - the value to set
        Returns:
        this builder instance

      • sqlHandle

        public ListSqlPlanBaselinesRequest.Builder sqlHandle​(String sqlHandle)
        A filter to return all the SQL plan baselines for the specified SQL handle.
        Parameters:
        sqlHandle - the value to set
        Returns:
        this builder instance

      • sqlText

        public ListSqlPlanBaselinesRequest.Builder sqlText​(String sqlText)
        A filter to return all the SQL plan baselines that match the SQL text.

        By default, the search is case insensitive. To run an exact or case-sensitive search, double-quote the search string. You may also use the ‘%’ symbol as a wildcard.

        Parameters:
        sqlText - the value to set
        Returns:
        this builder instance

      • isEnabled

        public ListSqlPlanBaselinesRequest.Builder isEnabled​(Boolean isEnabled)
        A filter to return only SQL plan baselines that are either enabled or not enabled.

        By default, all SQL plan baselines are returned.

        Parameters:
        isEnabled - the value to set
        Returns:
        this builder instance

      • isAccepted

        public ListSqlPlanBaselinesRequest.Builder isAccepted​(Boolean isAccepted)
        A filter to return only SQL plan baselines that are either accepted or not accepted.

        By default, all SQL plan baselines are returned.

        Parameters:
        isAccepted - the value to set
        Returns:
        this builder instance

      • isReproduced

        public ListSqlPlanBaselinesRequest.Builder isReproduced​(Boolean isReproduced)
        A filter to return only SQL plan baselines that were either reproduced or not reproduced by the optimizer.

        By default, all SQL plan baselines are returned.

        Parameters:
        isReproduced - the value to set
        Returns:
        this builder instance

      • isFixed

        public ListSqlPlanBaselinesRequest.Builder isFixed​(Boolean isFixed)
        A filter to return only SQL plan baselines that are either fixed or not fixed.

        By default, all SQL plan baselines are returned.

        Parameters:
        isFixed - the value to set
        Returns:
        this builder instance

      • isAdaptive

        public ListSqlPlanBaselinesRequest.Builder isAdaptive​(Boolean isAdaptive)
        A filter to return only SQL plan baselines that are either adaptive or not adaptive.

        By default, all SQL plan baselines are returned.

        Parameters:
        isAdaptive - the value to set
        Returns:
        this builder instance

      • page

        public ListSqlPlanBaselinesRequest.Builder page​(String page)
        The page token representing the page from where the next set of paginated results are retrieved.

        This is usually retrieved from a previous list call.

        Parameters:
        page - the value to set
        Returns:
        this builder instance

      • limit

        public ListSqlPlanBaselinesRequest.Builder limit​(Integer limit)
        The maximum number of records returned in the paginated response.
        Parameters:
        limit - the value to set
        Returns:
        this builder instance

      • sortOrder

        public ListSqlPlanBaselinesRequest.Builder sortOrder​(SortOrders sortOrder)
        The option to sort information in ascending (\u2018ASC\u2019) or descending (\u2018DESC\u2019) order.

        Descending order is the default order.

        Parameters:
        sortOrder - the value to set
        Returns:
        this builder instance

      • isAutoPurged

        public ListSqlPlanBaselinesRequest.Builder isAutoPurged​(Boolean isAutoPurged)
        A filter to return only SQL plan baselines that are either auto-purged or not auto-purged.

        By default, all SQL plan baselines are returned.

        Parameters:
        isAutoPurged - the value to set
        Returns:
        this builder instance

      • timeLastExecutedGreaterThan

        public ListSqlPlanBaselinesRequest.Builder timeLastExecutedGreaterThan​(Date timeLastExecutedGreaterThan)
        A filter to return only SQL plan baselines whose last execution time is after the specified value.

        By default, all SQL plan baselines are returned.

        Parameters:
        timeLastExecutedGreaterThan - the value to set
        Returns:
        this builder instance

      • timeLastExecutedLessThan

        public ListSqlPlanBaselinesRequest.Builder timeLastExecutedLessThan​(Date timeLastExecutedLessThan)
        A filter to return only SQL plan baselines whose last execution time is before the specified value.

        By default, all SQL plan baselines are returned.

        Parameters:
        timeLastExecutedLessThan - the value to set
        Returns:
        this builder instance

      • isNeverExecuted

        public ListSqlPlanBaselinesRequest.Builder isNeverExecuted​(Boolean isNeverExecuted)
        A filter to return only SQL plan baselines that are not executed till now.

        By default, all SQL plan baselines are returned.

        Parameters:
        isNeverExecuted - the value to set
        Returns:
        this builder instance

      • opcRequestId

        public ListSqlPlanBaselinesRequest.Builder opcRequestId​(String opcRequestId)
        The client request ID for tracing.
        Parameters:
        opcRequestId - the value to set
        Returns:
        this builder instance

      • opcNamedCredentialId

        public ListSqlPlanBaselinesRequest.Builder opcNamedCredentialId​(String opcNamedCredentialId)
        The OCID of the Named Credential.
        Parameters:
        opcNamedCredentialId - the value to set
        Returns:
        this builder instance

      • invocationCallback

        public ListSqlPlanBaselinesRequest.Builder invocationCallback​(com.oracle.bmc.http.client.RequestInterceptor invocationCallback)
        Set the invocation callback for the request to be built.
        Parameters:
        invocationCallback - the invocation callback to be set for the request
        Returns:
        this builder instance

      • retryConfiguration

        public ListSqlPlanBaselinesRequest.Builder retryConfiguration​(RetryConfiguration retryConfiguration)
        Set the retry configuration for the request to be built.
        Parameters:
        retryConfiguration - the retry configuration to be used for the request
        Returns:
        this builder instance