Try SpotterFetches details about a DatabaseHomeMetrics resource in Oracle Cloud Infrastructure
| "added in version" 2.9.0 of oracle.oci"
Authors: Oracle (@oracle)
preview | supported by community
Install with ansible-galaxy collection install oracle.oci:==5.0.0
collections:
- name: oracle.oci
version: 5.0.0Fetches 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
- security_token
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