Package com.oracle.bmc.databasemanagement.requests

Class 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/latest/databasemanagement/GetAwrDbSqlReportExample.java.html"target=”_blank"rel=“noopener noreferrer”>here to see how to use GetAwrDbSqlReportRequest.

    • 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.

      • 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.

      • 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>