Gets the health metrics for a fleet of databases.

GET {{baseUrl}}/fleetMetrics?managedDatabaseGroupId=<string>&compartmentId=<string>&compareBaselineTime=<string>&compareTargetTime=<string>&compareType=DAY&filterByMetricNames=<string>&filterByDatabaseType=<string>&filterByDatabaseSubType=<string>&page=<string>&limit=10&sortBy=TIMECREATED&sortOrder=ASC&filterByDatabaseDeploymentType=<string>&filterByDatabaseVersion=<string>&definedTagEquals=<string>&definedTagEquals=<string>&freeformTagEquals=<string>&freeformTagEquals=<string>&definedTagExists=<string>&definedTagExists=<string>&freeformTagExists=<string>&freeformTagExists=<string>

Gets the health metrics for a fleet of databases in a compartment or in a Managed Database Group. Either the CompartmentId or the ManagedDatabaseGroupId query parameters must be provided to retrieve the health metrics.

Request Params

KeyDatatypeRequiredDescription
managedDatabaseGroupIdstringThe OCID of the Managed Database Group.
compartmentIdstringThe OCID of the compartment.
compareBaselineTimestring(Required) The baseline time for metrics comparison.
compareTargetTimestring(Required) The target time for metrics comparison.
compareTypestringThe time window used for metrics comparison.
filterByMetricNamesstringThe 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.
filterByDatabaseTypestringThe filter used to filter the databases in the fleet by a specific Oracle Database type.
filterByDatabaseSubTypestringThe filter used to filter the databases in the fleet by a specific Oracle Database subtype.
pagestringThe page token representing the page from where the next set of paginated results
are retrieved. This is usually retrieved from a previous list call.
limitnumberThe maximum number of records returned in the paginated response.
sortBystringThe field to sort information by. Only one sortOrder can be used. The default sort order
for ‘TIMECREATED’ is descending and the default sort order for ‘NAME’ is ascending.
The ‘NAME’ sort order is case-sensitive.
sortOrderstringThe option to sort information in ascending (‘ASC’) or descending (‘DESC’) order. Ascending order is the default order.
filterByDatabaseDeploymentTypestringThe filter used to filter the databases in the fleet by a specific Oracle Database deployment type.
filterByDatabaseVersionstringThe filter used to filter the databases in the fleet by a specific Oracle Database version.
definedTagEqualsstringA 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".
definedTagEqualsstringA 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".
freeformTagEqualsstringA 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".
freeformTagEqualsstringA 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".
definedTagExistsstringA 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".
definedTagExistsstringA 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".
freeformTagExistsstringA 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".
freeformTagExistsstringA 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".

HEADERS

KeyDatatypeRequiredDescription
opc-request-idstringThe client request ID for tracing.
Acceptstring

RESPONSES

status: OK

{&quot;compareBaselineTime&quot;:&quot;\u003cstring\u003e&quot;,&quot;compareTargetTime&quot;:&quot;\u003cstring\u003e&quot;,&quot;fleetDatabases&quot;:[{&quot;compartmentId&quot;:&quot;\u003cstring\u003e&quot;,&quot;databaseContainerId&quot;:&quot;\u003cstring\u003e&quot;,&quot;databaseName&quot;:&quot;\u003cstring\u003e&quot;,&quot;databaseSubType&quot;:&quot;ADB&quot;,&quot;databaseType&quot;:&quot;CLOUD_RAC&quot;,&quot;databaseVersion&quot;:&quot;\u003cstring\u003e&quot;,&quot;dbId&quot;:&quot;\u003cstring\u003e&quot;,&quot;deploymentType&quot;:&quot;AUTONOMOUS&quot;,&quot;metrics&quot;:[{&quot;baselineValue&quot;:&quot;\u003cdouble\u003e&quot;,&quot;dimensions&quot;:[{&quot;dimensionName&quot;:&quot;\u003cstring\u003e&quot;,&quot;dimensionValue&quot;:&quot;\u003cstring\u003e&quot;},{&quot;dimensionName&quot;:&quot;\u003cstring\u003e&quot;,&quot;dimensionValue&quot;:&quot;\u003cstring\u003e&quot;}],&quot;metricName&quot;:&quot;\u003cstring\u003e&quot;,&quot;percentageChange&quot;:&quot;\u003cdouble\u003e&quot;,&quot;targetValue&quot;:&quot;\u003cdouble\u003e&quot;,&quot;timestamp&quot;:&quot;\u003cdateTime\u003e&quot;,&quot;unit&quot;:&quot;\u003cstring\u003e&quot;},{&quot;baselineValue&quot;:&quot;\u003cdouble\u003e&quot;,&quot;dimensions&quot;:[{&quot;dimensionName&quot;:&quot;\u003cstring\u003e&quot;,&quot;dimensionValue&quot;:&quot;\u003cstring\u003e&quot;},{&quot;dimensionName&quot;:&quot;\u003cstring\u003e&quot;,&quot;dimensionValue&quot;:&quot;\u003cstring\u003e&quot;}],&quot;metricName&quot;:&quot;\u003cstring\u003e&quot;,&quot;percentageChange&quot;:&quot;\u003cdouble\u003e&quot;,&quot;targetValue&quot;:&quot;\u003cdouble\u003e&quot;,&quot;timestamp&quot;:&quot;\u003cdateTime\u003e&quot;,&quot;unit&quot;:&quot;\u003cstring\u003e&quot;}],&quot;workloadType&quot;:&quot;APEX&quot;},{&quot;compartmentId&quot;:&quot;\u003cstring\u003e&quot;,&quot;databaseContainerId&quot;:&quot;\u003cstring\u003e&quot;,&quot;databaseName&quot;:&quot;\u003cstring\u003e&quot;,&quot;databaseSubType&quot;:&quot;NON_CDB&quot;,&quot;databaseType&quot;:&quot;CLOUD_RAC&quot;,&quot;databaseVersion&quot;:&quot;\u003cstring\u003e&quot;,&quot;dbId&quot;:&quot;\u003cstring\u003e&quot;,&quot;deploymentType&quot;:&quot;EXADATA_CC&quot;,&quot;metrics&quot;:[{&quot;baselineValue&quot;:&quot;\u003cdouble\u003e&quot;,&quot;dimensions&quot;:[{&quot;dimensionName&quot;:&quot;\u003cstring\u003e&quot;,&quot;dimensionValue&quot;:&quot;\u003cstring\u003e&quot;},{&quot;dimensionName&quot;:&quot;\u003cstring\u003e&quot;,&quot;dimensionValue&quot;:&quot;\u003cstring\u003e&quot;}],&quot;metricName&quot;:&quot;\u003cstring\u003e&quot;,&quot;percentageChange&quot;:&quot;\u003cdouble\u003e&quot;,&quot;targetValue&quot;:&quot;\u003cdouble\u003e&quot;,&quot;timestamp&quot;:&quot;\u003cdateTime\u003e&quot;,&quot;unit&quot;:&quot;\u003cstring\u003e&quot;},{&quot;baselineValue&quot;:&quot;\u003cdouble\u003e&quot;,&quot;dimensions&quot;:[{&quot;dimensionName&quot;:&quot;\u003cstring\u003e&quot;,&quot;dimensionValue&quot;:&quot;\u003cstring\u003e&quot;},{&quot;dimensionName&quot;:&quot;\u003cstring\u003e&quot;,&quot;dimensionValue&quot;:&quot;\u003cstring\u003e&quot;}],&quot;metricName&quot;:&quot;\u003cstring\u003e&quot;,&quot;percentageChange&quot;:&quot;\u003cdouble\u003e&quot;,&quot;targetValue&quot;:&quot;\u003cdouble\u003e&quot;,&quot;timestamp&quot;:&quot;\u003cdateTime\u003e&quot;,&quot;unit&quot;:&quot;\u003cstring\u003e&quot;}],&quot;workloadType&quot;:&quot;APEX&quot;}],&quot;compareType&quot;:&quot;DAY&quot;,&quot;fleetSummary&quot;:{&quot;aggregatedMetrics&quot;:[{&quot;baselineValue&quot;:&quot;\u003cdouble\u003e&quot;,&quot;dimensions&quot;:[{&quot;dimensionName&quot;:&quot;\u003cstring\u003e&quot;,&quot;dimensionValue&quot;:&quot;\u003cstring\u003e&quot;},{&quot;dimensionName&quot;:&quot;\u003cstring\u003e&quot;,&quot;dimensionValue&quot;:&quot;\u003cstring\u003e&quot;}],&quot;metricName&quot;:&quot;\u003cstring\u003e&quot;,&quot;percentageChange&quot;:&quot;\u003cdouble\u003e&quot;,&quot;targetValue&quot;:&quot;\u003cdouble\u003e&quot;,&quot;unit&quot;:&quot;\u003cstring\u003e&quot;},{&quot;baselineValue&quot;:&quot;\u003cdouble\u003e&quot;,&quot;dimensions&quot;:[{&quot;dimensionName&quot;:&quot;\u003cstring\u003e&quot;,&quot;dimensionValue&quot;:&quot;\u003cstring\u003e&quot;},{&quot;dimensionName&quot;:&quot;\u003cstring\u003e&quot;,&quot;dimensionValue&quot;:&quot;\u003cstring\u003e&quot;}],&quot;metricName&quot;:&quot;\u003cstring\u003e&quot;,&quot;percentageChange&quot;:&quot;\u003cdouble\u003e&quot;,&quot;targetValue&quot;:&quot;\u003cdouble\u003e&quot;,&quot;unit&quot;:&quot;\u003cstring\u003e&quot;}],&quot;inventory&quot;:[{&quot;databaseSubType&quot;:&quot;PDB&quot;,&quot;databaseType&quot;:&quot;CLOUD_SIDB&quot;,&quot;deploymentType&quot;:&quot;EXADATA_CC&quot;,&quot;inventoryCount&quot;:&quot;\u003cinteger\u003e&quot;},{&quot;databaseSubType&quot;:&quot;ACD&quot;,&quot;databaseType&quot;:&quot;SHARED&quot;,&quot;deploymentType&quot;:&quot;EXADATA_CC&quot;,&quot;inventoryCount&quot;:&quot;\u003cinteger\u003e&quot;}]}}