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/latest/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 classListSqlPlanBaselinesRequest.Builderstatic classListSqlPlanBaselinesRequest.SortByThe 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.Builderbuilder()Return a new builder for this request object.booleanequals(Object o)Uses getInvocationCallback and getRetryConfiguration to determine if passed request is equal to ‘this’.BooleangetIsAccepted()A filter to return only SQL plan baselines that are either accepted or not accepted.BooleangetIsAdaptive()A filter to return only SQL plan baselines that are either adaptive or not adaptive.BooleangetIsAutoPurged()A filter to return only SQL plan baselines that are either auto-purged or not auto-purged.BooleangetIsEnabled()A filter to return only SQL plan baselines that are either enabled or not enabled.BooleangetIsFixed()A filter to return only SQL plan baselines that are either fixed or not fixed.BooleangetIsNeverExecuted()A filter to return only SQL plan baselines that are not executed till now.BooleangetIsReproduced()A filter to return only SQL plan baselines that were either reproduced or not reproduced by the optimizer.IntegergetLimit()The maximum number of records returned in the paginated response.StringgetManagedDatabaseId()The OCID of the Managed Database.StringgetOpcNamedCredentialId()The OCID of the Named Credential.StringgetOpcRequestId()The client request ID for tracing.SqlPlanBaselineOrigingetOrigin()A filter to return all the SQL plan baselines that match the origin.StringgetPage()The page token representing the page from where the next set of paginated results are retrieved.StringgetPlanName()A filter to return only SQL plan baselines that match the plan name.ListSqlPlanBaselinesRequest.SortBygetSortBy()The option to sort the SQL plan baseline summary data.SortOrdersgetSortOrder()The option to sort information in ascending (\u2018ASC\u2019) or descending (\u2018DESC\u2019) order.StringgetSqlHandle()A filter to return all the SQL plan baselines for the specified SQL handle.StringgetSqlText()A filter to return all the SQL plan baselines that match the SQL text.DategetTimeLastExecutedGreaterThan()A filter to return only SQL plan baselines whose last execution time is after the specified value.DategetTimeLastExecutedLessThan()A filter to return only SQL plan baselines whose last execution time is before the specified value.inthashCode()Uses getInvocationCallback and getRetryConfiguration to generate a hash.ListSqlPlanBaselinesRequest.BuildertoBuilder()Return an instance ofListSqlPlanBaselinesRequest.Builderthat allows you to modify request properties.StringtoString()-
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.Builderthat allows you to modify request properties.- Returns:
- instance of
ListSqlPlanBaselinesRequest.Builderthat 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:BmcRequestUses getInvocationCallback and getRetryConfiguration to determine if passed request is equal to ‘this’.- Overrides:
equalsin classBmcRequest<Void>
-
hashCode
public int hashCode()
Description copied from class:BmcRequestUses getInvocationCallback and getRetryConfiguration to generate a hash.- Overrides:
hashCodein classBmcRequest<Void>
-
-