Class ListSqlPlanBaselinesRequest
- java.lang.Object
-
- com.oracle.bmc.requests.BmcRequest<Void>
-
- com.oracle.bmc.databasemanagement.requests.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.
-
-
Nested Class Summary
Nested Classes Modifier and Type Class Description static class
ListSqlPlanBaselinesRequest.Builder
static class
ListSqlPlanBaselinesRequest.SortBy
The option to sort the SQL plan baseline summary data.
-
Constructor Summary
Constructors Constructor Description ListSqlPlanBaselinesRequest()
-
Method Summary
All Methods Static Methods Instance Methods Concrete Methods Modifier and Type Method Description static ListSqlPlanBaselinesRequest.Builder
builder()
Return a new builder for this request object.boolean
equals(Object o)
Uses getInvocationCallback and getRetryConfiguration to determine if passed request is equal to ‘this’.Boolean
getIsAccepted()
A filter to return only SQL plan baselines that are either accepted or not accepted.Boolean
getIsAdaptive()
A filter to return only SQL plan baselines that are either adaptive or not adaptive.Boolean
getIsAutoPurged()
A filter to return only SQL plan baselines that are either auto-purged or not auto-purged.Boolean
getIsEnabled()
A filter to return only SQL plan baselines that are either enabled or not enabled.Boolean
getIsFixed()
A filter to return only SQL plan baselines that are either fixed or not fixed.Boolean
getIsNeverExecuted()
A filter to return only SQL plan baselines that are not executed till now.Boolean
getIsReproduced()
A filter to return only SQL plan baselines that were either reproduced or not reproduced by the optimizer.Integer
getLimit()
The maximum number of records returned in the paginated response.String
getManagedDatabaseId()
The OCID of the Managed Database.String
getOpcNamedCredentialId()
The OCID of the Named Credential.String
getOpcRequestId()
The client request ID for tracing.SqlPlanBaselineOrigin
getOrigin()
A filter to return all the SQL plan baselines that match the origin.String
getPage()
The page token representing the page from where the next set of paginated results are retrieved.String
getPlanName()
A filter to return only SQL plan baselines that match the plan name.ListSqlPlanBaselinesRequest.SortBy
getSortBy()
The option to sort the SQL plan baseline summary data.SortOrders
getSortOrder()
The option to sort information in ascending (\u2018ASC\u2019) or descending (\u2018DESC\u2019) order.String
getSqlHandle()
A filter to return all the SQL plan baselines for the specified SQL handle.String
getSqlText()
A filter to return all the SQL plan baselines that match the SQL text.Date
getTimeLastExecutedGreaterThan()
A filter to return only SQL plan baselines whose last execution time is after the specified value.Date
getTimeLastExecutedLessThan()
A filter to return only SQL plan baselines whose last execution time is before the specified value.int
hashCode()
Uses getInvocationCallback and getRetryConfiguration to generate a hash.ListSqlPlanBaselinesRequest.Builder
toBuilder()
Return an instance ofListSqlPlanBaselinesRequest.Builder
that allows you to modify request properties.String
toString()
-
Methods inherited from class com.oracle.bmc.requests.BmcRequest
getBody$, getInvocationCallback, getRetryConfiguration, setInvocationCallback, setRetryConfiguration, supportsExpect100Continue
-
-
-
-
Method Detail
-
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.
-
getSortBy
public ListSqlPlanBaselinesRequest.SortBy getSortBy()
The option to sort the SQL plan baseline summary data.
-
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.
-
toBuilder
public ListSqlPlanBaselinesRequest.Builder toBuilder()
Return an instance ofListSqlPlanBaselinesRequest.Builder
that allows you to modify request properties.- Returns:
- instance of
ListSqlPlanBaselinesRequest.Builder
that allows you to modify request properties.
-
builder
public static ListSqlPlanBaselinesRequest.Builder builder()
Return a new builder for this request object.- Returns:
- builder for the request object
-
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 classBmcRequest<Void>
-
hashCode
public int hashCode()
Description copied from class:BmcRequest
Uses getInvocationCallback and getRetryConfiguration to generate a hash.- Overrides:
hashCode
in classBmcRequest<Void>
-
-