SummarizeSqlStatisticsRequest (Oracle Cloud Infrastructure Java SDK

java.lang.Object
- com.oracle.bmc.requests.BmcRequest<Void>
- - com.oracle.bmc.opsi.requests.SummarizeSqlStatisticsRequest

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

Example: Click here to see how to use SummarizeSqlStatisticsRequest.

Nested Class Summary

Nested Classes
Modifier and Type	Class and Description
`static class`	`SummarizeSqlStatisticsRequest.Builder`
`static class`	`SummarizeSqlStatisticsRequest.Category` Filter sqls by one or more performance categories.
`static class`	`SummarizeSqlStatisticsRequest.DatabaseType` Filter by one or more database type.
`static class`	`SummarizeSqlStatisticsRequest.SortBy` The field to use when sorting SQL statistics.

Constructor Summary

Constructors
Constructor and Description

SummarizeSqlStatisticsRequest()

Constructors
Constructor and Description
`SummarizeSqlStatisticsRequest()`

Method Summary

All Methods Static Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`static SummarizeSqlStatisticsRequest.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`	`getAnalysisTimeInterval()` Specify time period in ISO 8601 format with respect to current time.
`List<SummarizeSqlStatisticsRequest.Category>`	`getCategory()` Filter sqls by one or more performance categories.
`List<String>`	`getCdbName()` Filter by one or more cdb name.
`String`	`getCompartmentId()` The OCID of the compartment.
`Boolean`	`getCompartmentIdInSubtree()` A flag to search all resources within a given compartment and all sub-compartments.
`List<String>`	`getDatabaseId()` Optional list of database OCIDs of the associated DBaaS entity.
`Double`	`getDatabaseTimePctGreaterThan()` Filter sqls by percentage of db time.
`List<SummarizeSqlStatisticsRequest.DatabaseType>`	`getDatabaseType()` Filter by one or more database type.
`List<String>`	`getDefinedTagEquals()` A list of tag filters to apply.
`List<String>`	`getDefinedTagExists()` A list of tag existence filters to apply.
`List<String>`	`getExadataInsightId()` Optional list of exadata insight resource OCIDs.
`List<String>`	`getFreeformTagEquals()` A list of tag filters to apply.
`List<String>`	`getFreeformTagExists()` A list of tag existence filters to apply.
`List<String>`	`getHostName()` Filter by one or more hostname.
`List<String>`	`getId()` Optional list of database insight resource OCIDs.
`Integer`	`getLimit()` For list pagination.
`String`	`getOpcRequestId()` Unique Oracle-assigned identifier for the request.
`String`	`getPage()` For list pagination.
`SummarizeSqlStatisticsRequest.SortBy`	`getSortBy()` The field to use when sorting SQL statistics.
`SortOrder`	`getSortOrder()` The sort order to use, either ascending (`ASC`) or descending (`DESC`).
`List<String>`	`getSqlIdentifier()` One or more unique SQL_IDs for a SQL Statement.
`Date`	`getTimeIntervalEnd()` Analysis end time in UTC in ISO 8601 format(exclusive).
`Date`	`getTimeIntervalStart()` Analysis start time in UTC in ISO 8601 format(inclusive).
`List<String>`	`getVmclusterName()` Optional list of Exadata Insight VM cluster name.
`int`	`hashCode()` Uses getInvocationCallback and getRetryConfiguration to generate a hash.
`SummarizeSqlStatisticsRequest.Builder`	`toBuilder()` Return an instance of `SummarizeSqlStatisticsRequest.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
  - SummarizeSqlStatisticsRequest
```
public SummarizeSqlStatisticsRequest()
```
- Method Detail
  - getCompartmentId
```
public String getCompartmentId()
```
    The OCID of the compartment.
  - getDatabaseType
```
public List<SummarizeSqlStatisticsRequest.DatabaseType> getDatabaseType()
```
    Filter by one or more database type. Possible values are ADW-S, ATP-S, ADW-D, ATP-D, EXTERNAL-PDB, EXTERNAL-NONCDB.
  - getDatabaseId
```
public List<String> getDatabaseId()
```
    Optional list of database OCIDs of the associated DBaaS entity.
  - getId
```
public List<String> getId()
```
    Optional list of database insight resource OCIDs.
  - getExadataInsightId
```
public List<String> getExadataInsightId()
```
    Optional list of exadata insight resource OCIDs.
  - getCdbName
```
public List<String> getCdbName()
```
    Filter by one or more cdb name.
  - getHostName
```
public List<String> getHostName()
```
    Filter by one or more hostname.
  - getDatabaseTimePctGreaterThan
```
public Double getDatabaseTimePctGreaterThan()
```
    Filter sqls by percentage of db time.
  - getSqlIdentifier
```
public List<String> getSqlIdentifier()
```
    One or more unique SQL_IDs for a SQL Statement. Example: 6rgjh9bjmy2s7
  - getAnalysisTimeInterval
```
public String getAnalysisTimeInterval()
```
    Specify time period in ISO 8601 format with respect to current time. Default is last 30 days represented by P30D. If timeInterval is specified, then timeIntervalStart and timeIntervalEnd will be ignored. Examples P90D (last 90 days), P4W (last 4 weeks), P2M (last 2 months), P1Y (last 12 months), . Maximum value allowed is 25 months prior to current time (P25M).
  - getTimeIntervalStart
```
public Date getTimeIntervalStart()
```
    Analysis start time in UTC in ISO 8601 format(inclusive). Example 2019-10-30T00:00:00Z (yyyy-MM-ddThh:mm:ssZ). The minimum allowed value is 2 years prior to the current day. timeIntervalStart and timeIntervalEnd parameters are used together. If analysisTimeInterval is specified, this parameter is ignored.
  - getTimeIntervalEnd
```
public Date getTimeIntervalEnd()
```
    Analysis end time in UTC in ISO 8601 format(exclusive). Example 2019-10-30T00:00:00Z (yyyy-MM-ddThh:mm:ssZ). timeIntervalStart and timeIntervalEnd are used together. If timeIntervalEnd is not specified, current time is used as timeIntervalEnd.
  - getLimit
```
public Integer getLimit()
```
    For list pagination. The maximum number of results per page, or items to return in a paginated “List” call. For important details about how pagination works, see List Pagination. Example: 50
  - getPage
```
public String getPage()
```
    For list pagination. The value of the opc-next-page response header from the previous “List” call. For important details about how pagination works, see List Pagination.
  - getOpcRequestId
```
public String getOpcRequestId()
```
    Unique Oracle-assigned identifier for the request. If you need to contact Oracle about a particular request, please provide the request ID.
  - getSortOrder
```
public SortOrder getSortOrder()
```
    The sort order to use, either ascending (ASC) or descending (DESC).
  - getSortBy
```
public SummarizeSqlStatisticsRequest.SortBy getSortBy()
```
    The field to use when sorting SQL statistics. Example: databaseTimeInSec
  - getCategory
```
public List<SummarizeSqlStatisticsRequest.Category> getCategory()
```
    Filter sqls by one or more performance categories.
  - getDefinedTagEquals
```
public List<String> getDefinedTagEquals()
```
    A list of tag filters to apply. Only resources with a defined tag matching the value will be returned. Each item in the list has the format “{namespace}.{tagName}.{value}”. All inputs are case-insensitive. Multiple values for the same key (i.e. same namespace and tag name) are interpreted as “OR”. Values for different keys (i.e. different namespaces, different tag names, or both) are interpreted as “AND”.
  - getFreeformTagEquals
```
public List<String> getFreeformTagEquals()
```
    A list of tag filters to apply. Only resources with a freeform tag matching the value will be returned. The key for each tag is “{tagName}.{value}”. All inputs are case-insensitive. Multiple values for the same tag name are interpreted as “OR”. Values for different tag names are interpreted as “AND”.
  - getDefinedTagExists
```
public List<String> getDefinedTagExists()
```
    A list of tag existence filters to apply. Only resources for which the specified defined tags exist will be returned. Each item in the list has the format “{namespace}.{tagName}.true” (for checking existence of a defined tag) or “{namespace}.true”. All inputs are case-insensitive. Currently, only existence (“true” at the end) is supported. Absence (“false” at the end) is not supported. Multiple values for the same key (i.e. same namespace and tag name) are interpreted as “OR”. Values for different keys (i.e. different namespaces, different tag names, or both) are interpreted as “AND”.
  - getFreeformTagExists
```
public List<String> getFreeformTagExists()
```
    A list of tag existence filters to apply. Only resources for which the specified freeform tags exist the value will be returned. The key for each tag is “{tagName}.true”. All inputs are case-insensitive. Currently, only existence (“true” at the end) is supported. Absence (“false” at the end) is not supported. Multiple values for different tag names are interpreted as “AND”.
  - getCompartmentIdInSubtree
```
public Boolean getCompartmentIdInSubtree()
```
    A flag to search all resources within a given compartment and all sub-compartments.
  - getVmclusterName
```
public List<String> getVmclusterName()
```
    Optional list of Exadata Insight VM cluster name.
  - toBuilder
```
public SummarizeSqlStatisticsRequest.Builder toBuilder()
```
    Return an instance of SummarizeSqlStatisticsRequest.Builder that allows you to modify request properties.
    
    Returns:
    
    instance of SummarizeSqlStatisticsRequest.Builder that allows you to modify request properties.
  - builder
```
public static SummarizeSqlStatisticsRequest.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 SummarizeSqlStatisticsRequest

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

SummarizeSqlStatisticsRequest

Method Detail

getCompartmentId

getDatabaseType

getDatabaseId

getId

getExadataInsightId

getCdbName

getHostName

getDatabaseTimePctGreaterThan

getSqlIdentifier

getAnalysisTimeInterval

getTimeIntervalStart

getTimeIntervalEnd

getLimit

getPage

getOpcRequestId

getSortOrder

getSortBy

getCategory

getDefinedTagEquals

getFreeformTagEquals

getDefinedTagExists

getFreeformTagExists

getCompartmentIdInSubtree

getVmclusterName

toBuilder

builder

toString

equals

hashCode