Gets a summary of the resource usage metrics like DB Time, CPU, User I/O, Wait, Storage, and Memory metrics for Pdb's under the container database.
GET {{baseUrl}}/managedDatabases/:managedDatabaseId/pdbMetrics?startTime=<string>&endTime=<string>&compartmentId=<string>&compareType=DAY&filterByMetricNames=<string>
Gets a summary of the resource usage metrics such as CPU, User I/O, and Storage for each PDB within a specific CDB. If comparmentId is specified, then the metrics for each PDB (within the CDB) in the specified compartment are retrieved. If compartmentId is not specified, then the metrics for all the PDBs within the CDB are retrieved.
Request Params
| Key | Datatype | Required | Description |
|---|---|---|---|
startTime | string | (Required) The start time of the time range to retrieve the health metrics of a Managed Database | |
| in UTC in ISO-8601 format, which is "yyyy-MM-dd'T'hh:mm:ss.sss'Z'". | |||
endTime | string | (Required) The end time of the time range to retrieve the health metrics of a Managed Database | |
| in UTC in ISO-8601 format, which is "yyyy-MM-dd'T'hh:mm:ss.sss'Z'". | |||
compartmentId | string | The OCID of the compartment. | |
compareType | string | The time window used for metrics comparison. | |
filterByMetricNames | string | The filter used to retrieve a specific set of metrics by passing the desired metric names with a comma separator. Note that, by default, the service returns all supported metrics. |
HEADERS
| Key | Datatype | Required | Description |
|---|---|---|---|
opc-request-id | string | The client request ID for tracing. | |
Accept | string |
RESPONSES
status: OK
{"databaseUsageMetrics":[{"compartmentId":"\u003cstring\u003e","databaseContainerId":"\u003cstring\u003e","databaseName":"\u003cstring\u003e","databaseSubType":"ACD","databaseType":"DEDICATED","databaseVersion":"\u003cstring\u003e","dbId":"\u003cstring\u003e","deploymentType":"BM","metrics":[{"baselineValue":"\u003cdouble\u003e","dimensions":[{"dimensionName":"\u003cstring\u003e","dimensionValue":"\u003cstring\u003e"},{"dimensionName":"\u003cstring\u003e","dimensionValue":"\u003cstring\u003e"}],"metricName":"\u003cstring\u003e","percentageChange":"\u003cdouble\u003e","targetValue":"\u003cdouble\u003e","timestamp":"\u003cdateTime\u003e","unit":"\u003cstring\u003e"},{"baselineValue":"\u003cdouble\u003e","dimensions":[{"dimensionName":"\u003cstring\u003e","dimensionValue":"\u003cstring\u003e"},{"dimensionName":"\u003cstring\u003e","dimensionValue":"\u003cstring\u003e"}],"metricName":"\u003cstring\u003e","percentageChange":"\u003cdouble\u003e","targetValue":"\u003cdouble\u003e","timestamp":"\u003cdateTime\u003e","unit":"\u003cstring\u003e"}],"workloadType":"APEX"},{"compartmentId":"\u003cstring\u003e","databaseContainerId":"\u003cstring\u003e","databaseName":"\u003cstring\u003e","databaseSubType":"ACD","databaseType":"CLOUD_SIDB","databaseVersion":"\u003cstring\u003e","dbId":"\u003cstring\u003e","deploymentType":"EXADATA_CC","metrics":[{"baselineValue":"\u003cdouble\u003e","dimensions":[{"dimensionName":"\u003cstring\u003e","dimensionValue":"\u003cstring\u003e"},{"dimensionName":"\u003cstring\u003e","dimensionValue":"\u003cstring\u003e"}],"metricName":"\u003cstring\u003e","percentageChange":"\u003cdouble\u003e","targetValue":"\u003cdouble\u003e","timestamp":"\u003cdateTime\u003e","unit":"\u003cstring\u003e"},{"baselineValue":"\u003cdouble\u003e","dimensions":[{"dimensionName":"\u003cstring\u003e","dimensionValue":"\u003cstring\u003e"},{"dimensionName":"\u003cstring\u003e","dimensionValue":"\u003cstring\u003e"}],"metricName":"\u003cstring\u003e","percentageChange":"\u003cdouble\u003e","targetValue":"\u003cdouble\u003e","timestamp":"\u003cdateTime\u003e","unit":"\u003cstring\u003e"}],"workloadType":"APEX"}]}