java.lang.Object
- com.oracle.bmc.requests.BmcRequest<Void>
- - com.oracle.bmc.databasemanagement.requests.GetAwrDbSqlReportRequest

```
@Generated(value="OracleSDKGenerator",
           comments="API Version: 20201101")
public class GetAwrDbSqlReportRequest
extends BmcRequest<Void>
```
Example: Click <a href=“https://docs.oracle.com/en-us/iaas/tools/java-sdk-examples/3.63.0/databasemanagement/GetAwrDbSqlReportExample.java.html"target=”_blank"rel=“noopener noreferrer”>here to see how to use GetAwrDbSqlReportRequest.

Nested Class Summary

Nested Classes
Modifier and Type Class Description

static class GetAwrDbSqlReportRequest.Builder

static class GetAwrDbSqlReportRequest.ReportFormat
The format of the AWR report.

Constructor Summary

Constructors
Constructor Description

GetAwrDbSqlReportRequest()

Method Summary

All Methods Static Methods Instance Methods Concrete Methods
Modifier and Type	Method	Description
`static GetAwrDbSqlReportRequest.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’.
`String`	`getAwrDbId()`	The parameter to filter the database by internal ID.
`Integer`	`getBeginSnIdGreaterThanOrEqualTo()`	The optional greater than or equal to filter on the snapshot ID.
`Integer`	`getContainerId()`	The optional query parameter to filter the database container by an exact ID value.
`Integer`	`getEndSnIdLessThanOrEqualTo()`	The optional less than or equal to query parameter to filter the snapshot ID.
`String`	`getInstNum()`	The optional single value query parameter to filter the database instance number.
`String`	`getManagedDatabaseId()`	The OCID of the Managed Database.
`String`	`getOpcNamedCredentialId()`	The OCID of the Named Credential.
`String`	`getOpcRequestId()`	The client request ID for tracing.
`String`	`getOpcRetryToken()`	A token that uniquely identifies a request so it can be retried in case of a timeout or server error without risk of executing that same action again.
`GetAwrDbSqlReportRequest.ReportFormat`	`getReportFormat()`	The format of the AWR report.
`String`	`getSqlId()`	The parameter to filter SQL by ID.
`Date`	`getTimeGreaterThanOrEqualTo()`	The optional greater than or equal to query parameter to filter the timestamp.
`Date`	`getTimeLessThanOrEqualTo()`	The optional less than or equal to query parameter to filter the timestamp.
`int`	`hashCode()`	Uses getInvocationCallback and getRetryConfiguration to generate a hash.
`GetAwrDbSqlReportRequest.Builder`	`toBuilder()`	Return an instance of `GetAwrDbSqlReportRequest.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
  - GetAwrDbSqlReportRequest
```
public GetAwrDbSqlReportRequest()
```
- Method Detail
  - getManagedDatabaseId
```
public String getManagedDatabaseId()
```
    The OCID of the Managed Database.
  - getAwrDbId
```
public String getAwrDbId()
```
    The parameter to filter the database by internal ID.
    Note that the internal ID of the database can be retrieved from the following endpoint: /managedDatabases/{managedDatabaseId}/awrDbs
  - getSqlId
```
public String getSqlId()
```
    The parameter to filter SQL by ID.
    Note that the SQL ID is generated internally by Oracle for each SQL statement and can be retrieved from AWR Report API (/managedDatabases/{managedDatabaseId}/awrDbs/{awrDbId}/awrDbReport) or Performance Hub API (/internal/managedDatabases/{managedDatabaseId}/actions/retrievePerformanceData)
  - getInstNum
```
public String getInstNum()
```
    The optional single value query parameter to filter the database instance number.
  - getBeginSnIdGreaterThanOrEqualTo
```
public Integer getBeginSnIdGreaterThanOrEqualTo()
```
    The optional greater than or equal to filter on the snapshot ID.
  - getEndSnIdLessThanOrEqualTo
```
public Integer getEndSnIdLessThanOrEqualTo()
```
    The optional less than or equal to query parameter to filter the snapshot ID.
  - getTimeGreaterThanOrEqualTo
```
public Date getTimeGreaterThanOrEqualTo()
```
    The optional greater than or equal to query parameter to filter the timestamp.
  - getTimeLessThanOrEqualTo
```
public Date getTimeLessThanOrEqualTo()
```
    The optional less than or equal to query parameter to filter the timestamp.
  - getReportFormat
```
public GetAwrDbSqlReportRequest.ReportFormat getReportFormat()
```
    The format of the AWR report.
  - getContainerId
```
public Integer getContainerId()
```
    The optional query parameter to filter the database container by an exact ID value.
    Note that the database container ID can be retrieved from the following endpoint: /managedDatabases/{managedDatabaseId}/awrDbSnapshotRanges
  - getOpcRequestId
```
public String getOpcRequestId()
```
    The client request ID for tracing.
  - getOpcRetryToken
```
public String getOpcRetryToken()
```
    A token that uniquely identifies a request so it can be retried in case of a timeout or server error without risk of executing that same action again.
    Retry tokens expire after 24 hours, but can be invalidated before then due to conflicting operations. For example, if a resource has been deleted and purged from the system, then a retry of the original creation request might be rejected.
  - getOpcNamedCredentialId
```
public String getOpcNamedCredentialId()
```
    The OCID of the Named Credential.
  - toBuilder
```
public GetAwrDbSqlReportRequest.Builder toBuilder()
```
    Return an instance of GetAwrDbSqlReportRequest.Builder that allows you to modify request properties.
    
    Returns:
    
    instance of GetAwrDbSqlReportRequest.Builder that allows you to modify request properties.
  - builder
```
public static GetAwrDbSqlReportRequest.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>

Modifier and Type	Class	Description
`static class`	`GetAwrDbSqlReportRequest.Builder`
`static class`	`GetAwrDbSqlReportRequest.ReportFormat`	The format of the AWR report.

Class GetAwrDbSqlReportRequest

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

GetAwrDbSqlReportRequest

Method Detail

getManagedDatabaseId

getAwrDbId

getSqlId

getInstNum

getBeginSnIdGreaterThanOrEqualTo

getEndSnIdLessThanOrEqualTo

getTimeGreaterThanOrEqualTo

getTimeLessThanOrEqualTo

getReportFormat

getContainerId

getOpcRequestId

getOpcRetryToken

getOpcNamedCredentialId

toBuilder

builder

toString

equals

hashCode