oracle / oracle.oci / 4.21.0 / module / oci_database_management_database_home_metrics_facts Fetches details about a DatabaseHomeMetrics resource in Oracle Cloud Infrastructure | "added in version" 2.9.0 of oracle.oci" Authors: Oracle (@oracle) preview | supported by communityoracle.oci.oci_database_management_database_home_metrics_facts (4.21.0) — module
Install with ansible-galaxy collection install oracle.oci:==4.21.0
collections: - name: oracle.oci version: 4.21.0
Fetches details about a DatabaseHomeMetrics resource in Oracle Cloud Infrastructure
Gets a summary of the activity and resource usage metrics like DB Time, CPU, User I/O, Wait, Storage, and Memory for a Managed Database.
- name: Get a specific database_home_metrics oci_database_management_database_home_metrics_facts: # required managed_database_id: "ocid1.manageddatabase.oc1..xxxxxxEXAMPLExxxxxx" start_time: start_time_example end_time: end_time_example
region: description: - The Oracle Cloud Infrastructure region to use for all OCI API requests. If not set, then the value of the OCI_REGION variable, if any, is used. This option is required if the region is not specified through a configuration file (See C(config_file_location)). Please refer to U(https://docs.us-phoenix-1.oraclecloud.com/Content/General/Concepts/regions.htm) for more information on OCI regions. type: str tenancy: description: - OCID of your tenancy. If not set, then the value of the OCI_TENANCY variable, if any, is used. This option is required if the tenancy OCID is not specified through a configuration file (See C(config_file_location)). To get the tenancy OCID, please refer U(https://docs.us-phoenix-1.oraclecloud.com/Content/API/Concepts/apisigningkey.htm) type: str api_user: description: - The OCID of the user, on whose behalf, OCI APIs are invoked. If not set, then the value of the OCI_USER_ID environment variable, if any, is used. This option is required if the user is not specified through a configuration file (See C(config_file_location)). To get the user's OCID, please refer U(https://docs.us-phoenix-1.oraclecloud.com/Content/API/Concepts/apisigningkey.htm). type: str end_time: description: - 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'". required: true type: str auth_type: choices: - api_key - instance_principal - instance_obo_user - resource_principal default: api_key description: - The type of authentication to use for making API requests. By default C(auth_type="api_key") based authentication is performed and the API key (see I(api_user_key_file)) in your config file will be used. If this 'auth_type' module option is not specified, the value of the OCI_ANSIBLE_AUTH_TYPE, if any, is used. Use C(auth_type="instance_principal") to use instance principal based authentication when running ansible playbooks within an OCI compute instance. type: str start_time: description: - 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'". required: true type: str cert_bundle: description: - The full path to a CA certificate bundle to be used for SSL verification. This will override the default CA certificate bundle. If not set, then the value of the OCI_ANSIBLE_CERT_BUNDLE variable, if any, is used. type: str auth_purpose: choices: - service_principal description: - The auth purpose which can be used in conjunction with 'auth_type=instance_principal'. The default auth_purpose for instance_principal is None. type: str api_user_key_file: description: - Full path and filename of the private key (in PEM format). If not set, then the value of the OCI_USER_KEY_FILE variable, if any, is used. This option is required if the private key is not specified through a configuration file (See C(config_file_location)). If the key is encrypted with a pass-phrase, the C(api_user_key_pass_phrase) option must also be provided. type: str config_profile_name: description: - The profile to load from the config file referenced by C(config_file_location). If not set, then the value of the OCI_CONFIG_PROFILE environment variable, if any, is used. Otherwise, defaults to the "DEFAULT" profile in C(config_file_location). type: str managed_database_id: description: - The L(OCID,https://docs.cloud.oracle.com/Content/General/Concepts/identifiers.htm) of the Managed Database. required: true type: str api_user_fingerprint: description: - Fingerprint for the key pair being used. If not set, then the value of the OCI_USER_FINGERPRINT environment variable, if any, is used. This option is required if the key fingerprint is not specified through a configuration file (See C(config_file_location)). To get the key pair's fingerprint value please refer U(https://docs.us-phoenix-1.oraclecloud.com/Content/API/Concepts/apisigningkey.htm). type: str config_file_location: description: - Path to configuration file. If not set then the value of the OCI_CONFIG_FILE environment variable, if any, is used. Otherwise, defaults to ~/.oci/config. type: str api_user_key_pass_phrase: description: - Passphrase used by the key referenced in C(api_user_key_file), if it is encrypted. If not set, then the value of the OCI_USER_KEY_PASS_PHRASE variable, if any, is used. This option is required if the key passphrase is not specified through a configuration file (See C(config_file_location)). type: str realm_specific_endpoint_template_enabled: description: - Enable/Disable realm specific endpoint template for service client. By Default, realm specific endpoint template is disabled. If not set, then the value of the OCI_REALM_SPECIFIC_SERVICE_ENDPOINT_TEMPLATE_ENABLED variable, if any, is used. type: bool
database_home_metrics: contains: database_home_metrics: contains: activity_time_series_metrics: contains: cluster: contains: dimensions: contains: dimension_name: description: - The name of the dimension. returned: on success sample: dimension_name_example type: str dimension_value: description: - The value of the dimension. returned: on success sample: dimension_value_example type: str description: - The dimensions of the metric. returned: on success type: complex unit: description: - The unit of the metric value. returned: on success sample: unit_example type: str value: description: - The value of the metric. returned: on success sample: 1.2 type: float description: - '' returned: on success type: complex cpu_count: contains: dimensions: contains: dimension_name: description: - The name of the dimension. returned: on success sample: dimension_name_example type: str dimension_value: description: - The value of the dimension. returned: on success sample: dimension_value_example type: str description: - The dimensions of the metric. returned: on success type: complex unit: description: - The unit of the metric value. returned: on success sample: unit_example type: str value: description: - The value of the metric. returned: on success sample: 1.2 type: float description: - '' returned: on success type: complex cpu_time: contains: dimensions: contains: dimension_name: description: - The name of the dimension. returned: on success sample: dimension_name_example type: str dimension_value: description: - The value of the dimension. returned: on success sample: dimension_value_example type: str description: - The dimensions of the metric. returned: on success type: complex unit: description: - The unit of the metric value. returned: on success sample: unit_example type: str value: description: - The value of the metric. returned: on success sample: 1.2 type: float description: - '' returned: on success type: complex timestamp: description: - The date and time the activity metric was created. returned: on success sample: '2013-10-20T19:20:30+01:00' type: str user_io_time: contains: dimensions: contains: dimension_name: description: - The name of the dimension. returned: on success sample: dimension_name_example type: str dimension_value: description: - The value of the dimension. returned: on success sample: dimension_value_example type: str description: - The dimensions of the metric. returned: on success type: complex unit: description: - The unit of the metric value. returned: on success sample: unit_example type: str value: description: - The value of the metric. returned: on success sample: 1.2 type: float description: - '' returned: on success type: complex wait_time: contains: dimensions: contains: dimension_name: description: - The name of the dimension. returned: on success sample: dimension_name_example type: str dimension_value: description: - The value of the dimension. returned: on success sample: dimension_value_example type: str description: - The dimensions of the metric. returned: on success type: complex unit: description: - The unit of the metric value. returned: on success sample: unit_example type: str value: description: - The value of the metric. returned: on success sample: 1.2 type: float description: - '' returned: on success type: complex description: - A list of the active session metrics for CPU and Wait time for a specific Managed Database. returned: on success type: complex cpu_utilization_aggregate_metrics: contains: cpu_statistics: contains: dimensions: contains: dimension_name: description: - The name of the dimension. returned: on success sample: dimension_name_example type: str dimension_value: description: - The value of the dimension. returned: on success sample: dimension_value_example type: str description: - The dimensions of the metric. returned: on success type: complex lower_quartile: description: - The first quartile value of the metric. returned: on success sample: 1.2 type: float max: description: - The maximum value of the metric. returned: on success sample: 1.2 type: float median: description: - The median value of the metric. returned: on success sample: 1.2 type: float min: description: - The minimum value of the metric. returned: on success sample: 1.2 type: float unit: description: - The unit of the metric value. returned: on success sample: unit_example type: str upper_quartile: description: - The third quartile value of the metric. returned: on success sample: 1.2 type: float description: - '' returned: on success type: complex cpu_utilization: contains: dimensions: contains: dimension_name: description: - The name of the dimension. returned: on success sample: dimension_name_example type: str dimension_value: description: - The value of the dimension. returned: on success sample: dimension_value_example type: str description: - The dimensions of the metric. returned: on success type: complex unit: description: - The unit of the metric value. returned: on success sample: unit_example type: str value: description: - The value of the metric. returned: on success sample: 1.2 type: float description: - '' returned: on success type: complex description: - '' returned: on success type: complex db_storage_aggregate_metrics: contains: storage_allocated: contains: dimensions: contains: dimension_name: description: - The name of the dimension. returned: on success sample: dimension_name_example type: str dimension_value: description: - The value of the dimension. returned: on success sample: dimension_value_example type: str description: - The dimensions of the metric. returned: on success type: complex unit: description: - The unit of the metric value. returned: on success sample: unit_example type: str value: description: - The value of the metric. returned: on success sample: 1.2 type: float description: - '' returned: on success type: complex storage_used: contains: dimensions: contains: dimension_name: description: - The name of the dimension. returned: on success sample: dimension_name_example type: str dimension_value: description: - The value of the dimension. returned: on success sample: dimension_value_example type: str description: - The dimensions of the metric. returned: on success type: complex unit: description: - The unit of the metric value. returned: on success sample: unit_example type: str value: description: - The value of the metric. returned: on success sample: 1.2 type: float description: - '' returned: on success type: complex storage_used_by_table_space: contains: dimensions: contains: dimension_name: description: - The name of the dimension. returned: on success sample: dimension_name_example type: str dimension_value: description: - The value of the dimension. returned: on success sample: dimension_value_example type: str description: - The dimensions of the metric. returned: on success type: complex unit: description: - The unit of the metric value. returned: on success sample: unit_example type: str value: description: - The value of the metric. returned: on success sample: 1.2 type: float description: - A list of the storage metrics grouped by TableSpace for a specific Managed Database. returned: on success type: complex description: - '' returned: on success type: complex db_time_aggregate_metrics: contains: cluster: contains: dimensions: contains: dimension_name: description: - The name of the dimension. returned: on success sample: dimension_name_example type: str dimension_value: description: - The value of the dimension. returned: on success sample: dimension_value_example type: str description: - The dimensions of the metric. returned: on success type: complex unit: description: - The unit of the metric value. returned: on success sample: unit_example type: str value: description: - The value of the metric. returned: on success sample: 1.2 type: float description: - '' returned: on success type: complex cpu_count: contains: dimensions: contains: dimension_name: description: - The name of the dimension. returned: on success sample: dimension_name_example type: str dimension_value: description: - The value of the dimension. returned: on success sample: dimension_value_example type: str description: - The dimensions of the metric. returned: on success type: complex unit: description: - The unit of the metric value. returned: on success sample: unit_example type: str value: description: - The value of the metric. returned: on success sample: 1.2 type: float description: - '' returned: on success type: complex cpu_time: contains: dimensions: contains: dimension_name: description: - The name of the dimension. returned: on success sample: dimension_name_example type: str dimension_value: description: - The value of the dimension. returned: on success sample: dimension_value_example type: str description: - The dimensions of the metric. returned: on success type: complex unit: description: - The unit of the metric value. returned: on success sample: unit_example type: str value: description: - The value of the metric. returned: on success sample: 1.2 type: float description: - '' returned: on success type: complex user_io_time: contains: dimensions: contains: dimension_name: description: - The name of the dimension. returned: on success sample: dimension_name_example type: str dimension_value: description: - The value of the dimension. returned: on success sample: dimension_value_example type: str description: - The dimensions of the metric. returned: on success type: complex unit: description: - The unit of the metric value. returned: on success sample: unit_example type: str value: description: - The value of the metric. returned: on success sample: 1.2 type: float description: - '' returned: on success type: complex wait_time: contains: dimensions: contains: dimension_name: description: - The name of the dimension. returned: on success sample: dimension_name_example type: str dimension_value: description: - The value of the dimension. returned: on success sample: dimension_value_example type: str description: - The dimensions of the metric. returned: on success type: complex unit: description: - The unit of the metric value. returned: on success sample: unit_example type: str value: description: - The value of the metric. returned: on success sample: 1.2 type: float description: - '' returned: on success type: complex description: - '' returned: on success type: complex failed_connections_aggregate_metrics: contains: failed_connections: contains: dimensions: contains: dimension_name: description: - The name of the dimension. returned: on success sample: dimension_name_example type: str dimension_value: description: - The value of the dimension. returned: on success sample: dimension_value_example type: str description: - The dimensions of the metric. returned: on success type: complex unit: description: - The unit of the metric value. returned: on success sample: unit_example type: str value: description: - The value of the metric. returned: on success sample: 1.2 type: float description: - '' returned: on success type: complex description: - '' returned: on success type: complex io_aggregate_metrics: contains: io_throughput: contains: dimensions: contains: dimension_name: description: - The name of the dimension. returned: on success sample: dimension_name_example type: str dimension_value: description: - The value of the dimension. returned: on success sample: dimension_value_example type: str description: - The dimensions of the metric. returned: on success type: complex unit: description: - The unit of the metric value. returned: on success sample: unit_example type: str value: description: - The value of the metric. returned: on success sample: 1.2 type: float description: - The IOThroughput metrics grouped by IOType for a specific Managed Database. returned: on success type: complex io_throughput_statistics: contains: dimensions: contains: dimension_name: description: - The name of the dimension. returned: on success sample: dimension_name_example type: str dimension_value: description: - The value of the dimension. returned: on success sample: dimension_value_example type: str description: - The dimensions of the metric. returned: on success type: complex lower_quartile: description: - The first quartile value of the metric. returned: on success sample: 1.2 type: float max: description: - The maximum value of the metric. returned: on success sample: 1.2 type: float median: description: - The median value of the metric. returned: on success sample: 1.2 type: float min: description: - The minimum value of the metric. returned: on success sample: 1.2 type: float unit: description: - The unit of the metric value. returned: on success sample: unit_example type: str upper_quartile: description: - The third quartile value of the metric. returned: on success sample: 1.2 type: float description: - The IOThroughput metric statistics such as min, max, mean, lowerQuartile, and upperQuartile. returned: on success type: complex iops: contains: dimensions: contains: dimension_name: description: - The name of the dimension. returned: on success sample: dimension_name_example type: str dimension_value: description: - The value of the dimension. returned: on success sample: dimension_value_example type: str description: - The dimensions of the metric. returned: on success type: complex unit: description: - The unit of the metric value. returned: on success sample: unit_example type: str value: description: - The value of the metric. returned: on success sample: 1.2 type: float description: - The Input/Output Operations Per Second metrics grouped by IOType for a specific Managed Database. returned: on success type: complex iops_statistics: contains: dimensions: contains: dimension_name: description: - The name of the dimension. returned: on success sample: dimension_name_example type: str dimension_value: description: - The value of the dimension. returned: on success sample: dimension_value_example type: str description: - The dimensions of the metric. returned: on success type: complex lower_quartile: description: - The first quartile value of the metric. returned: on success sample: 1.2 type: float max: description: - The maximum value of the metric. returned: on success sample: 1.2 type: float median: description: - The median value of the metric. returned: on success sample: 1.2 type: float min: description: - The minimum value of the metric. returned: on success sample: 1.2 type: float unit: description: - The unit of the metric value. returned: on success sample: unit_example type: str upper_quartile: description: - The third quartile value of the metric. returned: on success sample: 1.2 type: float description: - The Input/Output metric statistics such as min, max, mean, lowerQuartile, and upperQuartile. returned: on success type: complex description: - '' returned: on success type: complex memory_aggregate_metrics: contains: memory_usage: contains: dimensions: contains: dimension_name: description: - The name of the dimension. returned: on success sample: dimension_name_example type: str dimension_value: description: - The value of the dimension. returned: on success sample: dimension_value_example type: str description: - The dimensions of the metric. returned: on success type: complex unit: description: - The unit of the metric value. returned: on success sample: unit_example type: str value: description: - The value of the metric. returned: on success sample: 1.2 type: float description: - The Memory Usage metrics grouped by memorypool for a specific Managed Database. returned: on success type: complex description: - '' returned: on success type: complex statements_aggregate_metrics: contains: queued_statements: contains: dimensions: contains: dimension_name: description: - The name of the dimension. returned: on success sample: dimension_name_example type: str dimension_value: description: - The value of the dimension. returned: on success sample: dimension_value_example type: str description: - The dimensions of the metric. returned: on success type: complex unit: description: - The unit of the metric value. returned: on success sample: unit_example type: str value: description: - The value of the metric. returned: on success sample: 1.2 type: float description: - '' returned: on success type: complex running_statements: contains: dimensions: contains: dimension_name: description: - The name of the dimension. returned: on success sample: dimension_name_example type: str dimension_value: description: - The value of the dimension. returned: on success sample: dimension_value_example type: str description: - The dimensions of the metric. returned: on success type: complex unit: description: - The unit of the metric value. returned: on success sample: unit_example type: str value: description: - The value of the metric. returned: on success sample: 1.2 type: float description: - '' returned: on success type: complex description: - '' returned: on success type: complex description: - '' returned: on success type: complex database_instance_home_metrics: contains: activity_time_series_metrics: contains: cluster: contains: dimensions: contains: dimension_name: description: - The name of the dimension. returned: on success sample: dimension_name_example type: str dimension_value: description: - The value of the dimension. returned: on success sample: dimension_value_example type: str description: - The dimensions of the metric. returned: on success type: complex unit: description: - The unit of the metric value. returned: on success sample: unit_example type: str value: description: - The value of the metric. returned: on success sample: 1.2 type: float description: - '' returned: on success type: complex cpu_count: contains: dimensions: contains: dimension_name: description: - The name of the dimension. returned: on success sample: dimension_name_example type: str dimension_value: description: - The value of the dimension. returned: on success sample: dimension_value_example type: str description: - The dimensions of the metric. returned: on success type: complex unit: description: - The unit of the metric value. returned: on success sample: unit_example type: str value: description: - The value of the metric. returned: on success sample: 1.2 type: float description: - '' returned: on success type: complex cpu_time: contains: dimensions: contains: dimension_name: description: - The name of the dimension. returned: on success sample: dimension_name_example type: str dimension_value: description: - The value of the dimension. returned: on success sample: dimension_value_example type: str description: - The dimensions of the metric. returned: on success type: complex unit: description: - The unit of the metric value. returned: on success sample: unit_example type: str value: description: - The value of the metric. returned: on success sample: 1.2 type: float description: - '' returned: on success type: complex timestamp: description: - The date and time the activity metric was created. returned: on success sample: '2013-10-20T19:20:30+01:00' type: str user_io_time: contains: dimensions: contains: dimension_name: description: - The name of the dimension. returned: on success sample: dimension_name_example type: str dimension_value: description: - The value of the dimension. returned: on success sample: dimension_value_example type: str description: - The dimensions of the metric. returned: on success type: complex unit: description: - The unit of the metric value. returned: on success sample: unit_example type: str value: description: - The value of the metric. returned: on success sample: 1.2 type: float description: - '' returned: on success type: complex wait_time: contains: dimensions: contains: dimension_name: description: - The name of the dimension. returned: on success sample: dimension_name_example type: str dimension_value: description: - The value of the dimension. returned: on success sample: dimension_value_example type: str description: - The dimensions of the metric. returned: on success type: complex unit: description: - The unit of the metric value. returned: on success sample: unit_example type: str value: description: - The value of the metric. returned: on success sample: 1.2 type: float description: - '' returned: on success type: complex description: - A list of the active session metrics for CPU and Wait time for a specific Oracle Real Application Clusters (Oracle RAC) database instance. returned: on success type: complex cpu_utilization_aggregate_metrics: contains: cpu_statistics: contains: dimensions: contains: dimension_name: description: - The name of the dimension. returned: on success sample: dimension_name_example type: str dimension_value: description: - The value of the dimension. returned: on success sample: dimension_value_example type: str description: - The dimensions of the metric. returned: on success type: complex lower_quartile: description: - The first quartile value of the metric. returned: on success sample: 1.2 type: float max: description: - The maximum value of the metric. returned: on success sample: 1.2 type: float median: description: - The median value of the metric. returned: on success sample: 1.2 type: float min: description: - The minimum value of the metric. returned: on success sample: 1.2 type: float unit: description: - The unit of the metric value. returned: on success sample: unit_example type: str upper_quartile: description: - The third quartile value of the metric. returned: on success sample: 1.2 type: float description: - '' returned: on success type: complex cpu_utilization: contains: dimensions: contains: dimension_name: description: - The name of the dimension. returned: on success sample: dimension_name_example type: str dimension_value: description: - The value of the dimension. returned: on success sample: dimension_value_example type: str description: - The dimensions of the metric. returned: on success type: complex unit: description: - The unit of the metric value. returned: on success sample: unit_example type: str value: description: - The value of the metric. returned: on success sample: 1.2 type: float description: - '' returned: on success type: complex description: - '' returned: on success type: complex db_time_aggregate_metrics: contains: cluster: contains: dimensions: contains: dimension_name: description: - The name of the dimension. returned: on success sample: dimension_name_example type: str dimension_value: description: - The value of the dimension. returned: on success sample: dimension_value_example type: str description: - The dimensions of the metric. returned: on success type: complex unit: description: - The unit of the metric value. returned: on success sample: unit_example type: str value: description: - The value of the metric. returned: on success sample: 1.2 type: float description: - '' returned: on success type: complex cpu_count: contains: dimensions: contains: dimension_name: description: - The name of the dimension. returned: on success sample: dimension_name_example type: str dimension_value: description: - The value of the dimension. returned: on success sample: dimension_value_example type: str description: - The dimensions of the metric. returned: on success type: complex unit: description: - The unit of the metric value. returned: on success sample: unit_example type: str value: description: - The value of the metric. returned: on success sample: 1.2 type: float description: - '' returned: on success type: complex cpu_time: contains: dimensions: contains: dimension_name: description: - The name of the dimension. returned: on success sample: dimension_name_example type: str dimension_value: description: - The value of the dimension. returned: on success sample: dimension_value_example type: str description: - The dimensions of the metric. returned: on success type: complex unit: description: - The unit of the metric value. returned: on success sample: unit_example type: str value: description: - The value of the metric. returned: on success sample: 1.2 type: float description: - '' returned: on success type: complex user_io_time: contains: dimensions: contains: dimension_name: description: - The name of the dimension. returned: on success sample: dimension_name_example type: str dimension_value: description: - The value of the dimension. returned: on success sample: dimension_value_example type: str description: - The dimensions of the metric. returned: on success type: complex unit: description: - The unit of the metric value. returned: on success sample: unit_example type: str value: description: - The value of the metric. returned: on success sample: 1.2 type: float description: - '' returned: on success type: complex wait_time: contains: dimensions: contains: dimension_name: description: - The name of the dimension. returned: on success sample: dimension_name_example type: str dimension_value: description: - The value of the dimension. returned: on success sample: dimension_value_example type: str description: - The dimensions of the metric. returned: on success type: complex unit: description: - The unit of the metric value. returned: on success sample: unit_example type: str value: description: - The value of the metric. returned: on success sample: 1.2 type: float description: - '' returned: on success type: complex description: - '' returned: on success type: complex instance_name: description: - The name of the Oracle Real Application Clusters (Oracle RAC) database instance to which the corresponding metrics belong. returned: on success sample: instance_name_example type: str instance_number: description: - The number of Oracle Real Application Clusters (Oracle RAC) database instance to which the corresponding metrics belong. returned: on success sample: 56 type: int io_aggregate_metrics: contains: io_throughput: contains: dimensions: contains: dimension_name: description: - The name of the dimension. returned: on success sample: dimension_name_example type: str dimension_value: description: - The value of the dimension. returned: on success sample: dimension_value_example type: str description: - The dimensions of the metric. returned: on success type: complex unit: description: - The unit of the metric value. returned: on success sample: unit_example type: str value: description: - The value of the metric. returned: on success sample: 1.2 type: float description: - The IOThroughput metrics grouped by IOType for a specific Managed Database. returned: on success type: complex io_throughput_statistics: contains: dimensions: contains: dimension_name: description: - The name of the dimension. returned: on success sample: dimension_name_example type: str dimension_value: description: - The value of the dimension. returned: on success sample: dimension_value_example type: str description: - The dimensions of the metric. returned: on success type: complex lower_quartile: description: - The first quartile value of the metric. returned: on success sample: 1.2 type: float max: description: - The maximum value of the metric. returned: on success sample: 1.2 type: float median: description: - The median value of the metric. returned: on success sample: 1.2 type: float min: description: - The minimum value of the metric. returned: on success sample: 1.2 type: float unit: description: - The unit of the metric value. returned: on success sample: unit_example type: str upper_quartile: description: - The third quartile value of the metric. returned: on success sample: 1.2 type: float description: - The IOThroughput metric statistics such as min, max, mean, lowerQuartile, and upperQuartile. returned: on success type: complex iops: contains: dimensions: contains: dimension_name: description: - The name of the dimension. returned: on success sample: dimension_name_example type: str dimension_value: description: - The value of the dimension. returned: on success sample: dimension_value_example type: str description: - The dimensions of the metric. returned: on success type: complex unit: description: - The unit of the metric value. returned: on success sample: unit_example type: str value: description: - The value of the metric. returned: on success sample: 1.2 type: float description: - The Input/Output Operations Per Second metrics grouped by IOType for a specific Managed Database. returned: on success type: complex iops_statistics: contains: dimensions: contains: dimension_name: description: - The name of the dimension. returned: on success sample: dimension_name_example type: str dimension_value: description: - The value of the dimension. returned: on success sample: dimension_value_example type: str description: - The dimensions of the metric. returned: on success type: complex lower_quartile: description: - The first quartile value of the metric. returned: on success sample: 1.2 type: float max: description: - The maximum value of the metric. returned: on success sample: 1.2 type: float median: description: - The median value of the metric. returned: on success sample: 1.2 type: float min: description: - The minimum value of the metric. returned: on success sample: 1.2 type: float unit: description: - The unit of the metric value. returned: on success sample: unit_example type: str upper_quartile: description: - The third quartile value of the metric. returned: on success sample: 1.2 type: float description: - The Input/Output metric statistics such as min, max, mean, lowerQuartile, and upperQuartile. returned: on success type: complex description: - '' returned: on success type: complex memory_aggregate_metrics: contains: memory_usage: contains: dimensions: contains: dimension_name: description: - The name of the dimension. returned: on success sample: dimension_name_example type: str dimension_value: description: - The value of the dimension. returned: on success sample: dimension_value_example type: str description: - The dimensions of the metric. returned: on success type: complex unit: description: - The unit of the metric value. returned: on success sample: unit_example type: str value: description: - The value of the metric. returned: on success sample: 1.2 type: float description: - The Memory Usage metrics grouped by memorypool for a specific Managed Database. returned: on success type: complex description: - '' returned: on success type: complex description: - The metrics for the RAC database instances. returned: on success type: complex description: - DatabaseHomeMetrics resource returned: on success sample: database_home_metrics: activity_time_series_metrics: - cluster: dimensions: - dimension_name: dimension_name_example dimension_value: dimension_value_example unit: unit_example value: 1.2 cpu_count: dimensions: - dimension_name: dimension_name_example dimension_value: dimension_value_example unit: unit_example value: 1.2 cpu_time: dimensions: - dimension_name: dimension_name_example dimension_value: dimension_value_example unit: unit_example value: 1.2 timestamp: '2013-10-20T19:20:30+01:00' user_io_time: dimensions: - dimension_name: dimension_name_example dimension_value: dimension_value_example unit: unit_example value: 1.2 wait_time: dimensions: - dimension_name: dimension_name_example dimension_value: dimension_value_example unit: unit_example value: 1.2 cpu_utilization_aggregate_metrics: cpu_statistics: dimensions: - dimension_name: dimension_name_example dimension_value: dimension_value_example lower_quartile: 1.2 max: 1.2 median: 1.2 min: 1.2 unit: unit_example upper_quartile: 1.2 cpu_utilization: dimensions: - dimension_name: dimension_name_example dimension_value: dimension_value_example unit: unit_example value: 1.2 db_storage_aggregate_metrics: storage_allocated: dimensions: - dimension_name: dimension_name_example dimension_value: dimension_value_example unit: unit_example value: 1.2 storage_used: dimensions: - dimension_name: dimension_name_example dimension_value: dimension_value_example unit: unit_example value: 1.2 storage_used_by_table_space: - dimensions: - dimension_name: dimension_name_example dimension_value: dimension_value_example unit: unit_example value: 1.2 db_time_aggregate_metrics: cluster: dimensions: - dimension_name: dimension_name_example dimension_value: dimension_value_example unit: unit_example value: 1.2 cpu_count: dimensions: - dimension_name: dimension_name_example dimension_value: dimension_value_example unit: unit_example value: 1.2 cpu_time: dimensions: - dimension_name: dimension_name_example dimension_value: dimension_value_example unit: unit_example value: 1.2 user_io_time: dimensions: - dimension_name: dimension_name_example dimension_value: dimension_value_example unit: unit_example value: 1.2 wait_time: dimensions: - dimension_name: dimension_name_example dimension_value: dimension_value_example unit: unit_example value: 1.2 failed_connections_aggregate_metrics: failed_connections: dimensions: - dimension_name: dimension_name_example dimension_value: dimension_value_example unit: unit_example value: 1.2 io_aggregate_metrics: io_throughput: - dimensions: - dimension_name: dimension_name_example dimension_value: dimension_value_example unit: unit_example value: 1.2 io_throughput_statistics: - dimensions: - dimension_name: dimension_name_example dimension_value: dimension_value_example lower_quartile: 1.2 max: 1.2 median: 1.2 min: 1.2 unit: unit_example upper_quartile: 1.2 iops: - dimensions: - dimension_name: dimension_name_example dimension_value: dimension_value_example unit: unit_example value: 1.2 iops_statistics: - dimensions: - dimension_name: dimension_name_example dimension_value: dimension_value_example lower_quartile: 1.2 max: 1.2 median: 1.2 min: 1.2 unit: unit_example upper_quartile: 1.2 memory_aggregate_metrics: memory_usage: - dimensions: - dimension_name: dimension_name_example dimension_value: dimension_value_example unit: unit_example value: 1.2 statements_aggregate_metrics: queued_statements: dimensions: - dimension_name: dimension_name_example dimension_value: dimension_value_example unit: unit_example value: 1.2 running_statements: dimensions: - dimension_name: dimension_name_example dimension_value: dimension_value_example unit: unit_example value: 1.2 database_instance_home_metrics: - activity_time_series_metrics: - cluster: dimensions: - dimension_name: dimension_name_example dimension_value: dimension_value_example unit: unit_example value: 1.2 cpu_count: dimensions: - dimension_name: dimension_name_example dimension_value: dimension_value_example unit: unit_example value: 1.2 cpu_time: dimensions: - dimension_name: dimension_name_example dimension_value: dimension_value_example unit: unit_example value: 1.2 timestamp: '2013-10-20T19:20:30+01:00' user_io_time: dimensions: - dimension_name: dimension_name_example dimension_value: dimension_value_example unit: unit_example value: 1.2 wait_time: dimensions: - dimension_name: dimension_name_example dimension_value: dimension_value_example unit: unit_example value: 1.2 cpu_utilization_aggregate_metrics: cpu_statistics: dimensions: - dimension_name: dimension_name_example dimension_value: dimension_value_example lower_quartile: 1.2 max: 1.2 median: 1.2 min: 1.2 unit: unit_example upper_quartile: 1.2 cpu_utilization: dimensions: - dimension_name: dimension_name_example dimension_value: dimension_value_example unit: unit_example value: 1.2 db_time_aggregate_metrics: cluster: dimensions: - dimension_name: dimension_name_example dimension_value: dimension_value_example unit: unit_example value: 1.2 cpu_count: dimensions: - dimension_name: dimension_name_example dimension_value: dimension_value_example unit: unit_example value: 1.2 cpu_time: dimensions: - dimension_name: dimension_name_example dimension_value: dimension_value_example unit: unit_example value: 1.2 user_io_time: dimensions: - dimension_name: dimension_name_example dimension_value: dimension_value_example unit: unit_example value: 1.2 wait_time: dimensions: - dimension_name: dimension_name_example dimension_value: dimension_value_example unit: unit_example value: 1.2 instance_name: instance_name_example instance_number: 56 io_aggregate_metrics: io_throughput: - dimensions: - dimension_name: dimension_name_example dimension_value: dimension_value_example unit: unit_example value: 1.2 io_throughput_statistics: - dimensions: - dimension_name: dimension_name_example dimension_value: dimension_value_example lower_quartile: 1.2 max: 1.2 median: 1.2 min: 1.2 unit: unit_example upper_quartile: 1.2 iops: - dimensions: - dimension_name: dimension_name_example dimension_value: dimension_value_example unit: unit_example value: 1.2 iops_statistics: - dimensions: - dimension_name: dimension_name_example dimension_value: dimension_value_example lower_quartile: 1.2 max: 1.2 median: 1.2 min: 1.2 unit: unit_example upper_quartile: 1.2 memory_aggregate_metrics: memory_usage: - dimensions: - dimension_name: dimension_name_example dimension_value: dimension_value_example unit: unit_example value: 1.2 type: complex