Gets the SQL health check report for the SQL statement specified by the SQL ID.
GET {{baseUrl}}/managedDatabases/:managedDatabaseId/awrDbs/:awrDbId/awrDbSqlReport?instNum=<string>&beginSnIdGreaterThanOrEqualTo=<integer>&endSnIdLessThanOrEqualTo=<integer>&timeGreaterThanOrEqualTo=<dateTime>&timeLessThanOrEqualTo=<dateTime>&sqlId=<string>&reportFormat=HTML&containerId=<integer>
Gets the SQL health check report for one SQL of the specific database.
Request Params
| Key | Datatype | Required | Description |
|---|---|---|---|
instNum | string | The optional single value query parameter to filter the database instance number. | |
beginSnIdGreaterThanOrEqualTo | string | The optional greater than or equal to filter on the snapshot ID. | |
endSnIdLessThanOrEqualTo | string | The optional less than or equal to query parameter to filter the snapshot ID. | |
timeGreaterThanOrEqualTo | string | The optional greater than or equal to query parameter to filter the timestamp. | |
timeLessThanOrEqualTo | string | The optional less than or equal to query parameter to filter the timestamp. | |
sqlId | string | (Required) 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) | |
reportFormat | string | The format of the AWR report. | |
containerId | string | 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 | |||
HEADERS
| Key | Datatype | Required | Description |
|---|---|---|---|
opc-request-id | string | The client request ID for tracing. | |
opc-retry-token | string | 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. | |||
opc-named-credential-id | string | The OCID of the Named Credential. | |
Accept | string |
RESPONSES
status: OK
{"name":"\u003cstring\u003e","awrResultType":"AWRDB_DB_PARAMETER_CHANGE","dbQueryTimeInSecs":"\u003cdouble\u003e","queryKey":"\u003cstring\u003e","version":"\u003cstring\u003e","content":"\u003cstring\u003e","format":"HTML"}