ListSqlPlanBaselinesRequest (Oracle Cloud Infrastructure Java SDK

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 here to see how to use ListSqlPlanBaselinesRequest.

Nested Class Summary

Nested Classes
Modifier and Type	Class and Description
`static class`	`ListSqlPlanBaselinesRequest.Builder`
`static class`	`ListSqlPlanBaselinesRequest.SortBy` The option to sort the SQL plan baseline summary data.

Constructor Summary

Constructors
Constructor and Description

ListSqlPlanBaselinesRequest()

Constructors
Constructor and Description
`ListSqlPlanBaselinesRequest()`

Method Summary

All Methods Static Methods Instance Methods Concrete Methods
Modifier and Type	Method and 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 (‘ASC’) or descending (‘DESC’) 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 of `ListSqlPlanBaselinesRequest.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

Methods inherited from class java.lang.Object
clone, finalize, getClass, notify, notifyAll, wait, wait, wait

- 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.
  - 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 (‘ASC’) or descending (‘DESC’) 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 of ListSqlPlanBaselinesRequest.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
  - toString
```
public String toString()
```
    Overrides:
    
    toString in class 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 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>

Class ListSqlPlanBaselinesRequest

Nested Class Summary

Constructor Summary

Method Summary

Methods inherited from class com.oracle.bmc.requests.BmcRequest

Methods inherited from class java.lang.Object

Constructor Detail

ListSqlPlanBaselinesRequest

Method Detail

getManagedDatabaseId

getPlanName

getSqlHandle

getSqlText

getIsEnabled

getIsAccepted

getIsReproduced

getIsFixed

getIsAdaptive

getOrigin

getPage

getLimit

getSortBy

getSortOrder

getIsAutoPurged

getTimeLastExecutedGreaterThan

getTimeLastExecutedLessThan

getIsNeverExecuted

getOpcRequestId

getOpcNamedCredentialId

toBuilder

builder

toString

equals

hashCode