Class ListSqlPlanBaselinesRequest


  • @Generated(value="OracleSDKGenerator",
               comments="API Version: 20201101")
    public class ListSqlPlanBaselinesRequest
    extends BmcRequest<Void>

    Example: Click <a href=“https://docs.oracle.com/en-us/iaas/tools/java-sdk-examples/3.63.0/databasemanagement/ListSqlPlanBaselinesExample.java.html"target=”_blank"rel=“noopener noreferrer”>here to see how to use ListSqlPlanBaselinesRequest.

    • Constructor Detail

      • ListSqlPlanBaselinesRequest

        public ListSqlPlanBaselinesRequest()
    • Method Detail

      • getManagedDatabaseId

        public String getManagedDatabaseId()
        The OCID of the Managed Database.
      • getPlanName

        public String getPlanName()
        A filter to return only SQL plan baselines that match the plan name.
      • getSqlHandle

        public String getSqlHandle()
        A filter to return all the SQL plan baselines for the specified SQL handle.
      • getSqlText

        public String getSqlText()
        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.

      • getIsEnabled

        public Boolean getIsEnabled()
        A filter to return only SQL plan baselines that are either enabled or not enabled.

        By default, all SQL plan baselines are returned.

      • getIsAccepted

        public Boolean getIsAccepted()
        A filter to return only SQL plan baselines that are either accepted or not accepted.

        By default, all SQL plan baselines are returned.

      • getIsReproduced

        public Boolean getIsReproduced()
        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.

      • getIsFixed

        public Boolean getIsFixed()
        A filter to return only SQL plan baselines that are either fixed or not fixed.

        By default, all SQL plan baselines are returned.

      • getIsAdaptive

        public Boolean getIsAdaptive()
        A filter to return only SQL plan baselines that are either adaptive or not adaptive.

        By default, all SQL plan baselines are returned.

      • getOrigin

        public SqlPlanBaselineOrigin getOrigin()
        A filter to return all the SQL plan baselines that match the origin.
      • getPage

        public String getPage()
        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.

      • getLimit

        public Integer getLimit()
        The maximum number of records returned in the paginated response.
      • getSortOrder

        public SortOrders getSortOrder()
        The option to sort information in ascending (\u2018ASC\u2019) or descending (\u2018DESC\u2019) order.

        Descending order is the default order.

      • getIsAutoPurged

        public Boolean getIsAutoPurged()
        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.

      • getTimeLastExecutedGreaterThan

        public Date getTimeLastExecutedGreaterThan()
        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.

      • getTimeLastExecutedLessThan

        public Date getTimeLastExecutedLessThan()
        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.

      • getIsNeverExecuted

        public Boolean getIsNeverExecuted()
        A filter to return only SQL plan baselines that are not executed till now.

        By default, all SQL plan baselines are returned.

      • getOpcRequestId

        public String getOpcRequestId()
        The client request ID for tracing.
      • getOpcNamedCredentialId

        public String getOpcNamedCredentialId()
        The OCID of the Named Credential.
      • equals

        public boolean equals​(Object o)
        Description copied from class: BmcRequest
        Uses getInvocationCallback and getRetryConfiguration to determine if passed request is equal to ‘this’.
        Overrides:
        equals in class BmcRequest<Void>
      • hashCode

        public int hashCode()
        Description copied from class: BmcRequest
        Uses getInvocationCallback and getRetryConfiguration to generate a hash.
        Overrides:
        hashCode in class BmcRequest<Void>