steampipe plugin install ocisteampipe plugin install oci

oci_ai_anomaly_detection_ai_private_endpoint oci_ai_anomaly_detection_data_asset oci_ai_anomaly_detection_model oci_ai_anomaly_detection_project oci_analytics_instance oci_apigateway_api oci_artifacts_container_image oci_artifacts_container_image_signature oci_artifacts_container_repository oci_artifacts_generic_artifact oci_artifacts_repository oci_autoscaling_auto_scaling_configuration oci_bastion_bastion oci_bastion_session oci_budget_alert_rule oci_budget_budget oci_cloud_guard_configuration oci_cloud_guard_detector_recipe oci_cloud_guard_managed_list oci_cloud_guard_responder_recipe oci_cloud_guard_target oci_containerengine_cluster oci_core_block_volume_replica oci_core_boot_volume oci_core_boot_volume_attachment oci_core_boot_volume_backup oci_core_boot_volume_metric_read_ops oci_core_boot_volume_metric_read_ops_daily oci_core_boot_volume_metric_read_ops_hourly oci_core_boot_volume_metric_write_ops oci_core_boot_volume_metric_write_ops_daily oci_core_boot_volume_metric_write_ops_hourly oci_core_boot_volume_replica oci_core_cluster_network oci_core_dhcp_options oci_core_drg oci_core_image oci_core_image_custom oci_core_instance oci_core_instance_configuration oci_core_instance_metric_cpu_utilization oci_core_instance_metric_cpu_utilization_daily oci_core_instance_metric_cpu_utilization_hourly oci_core_internet_gateway oci_core_load_balancer oci_core_local_peering_gateway oci_core_nat_gateway oci_core_network_load_balancer oci_core_network_security_group oci_core_public_ip oci_core_public_ip_pool oci_core_route_table oci_core_security_list oci_core_service_gateway oci_core_subnet oci_core_vcn oci_core_vnic_attachment oci_core_volume oci_core_volume_attachment oci_core_volume_backup oci_core_volume_backup_policy oci_core_volume_default_backup_policy oci_core_volume_group oci_database_autonomous_database oci_database_autonomous_db_metric_cpu_utilization oci_database_autonomous_db_metric_cpu_utilization_daily oci_database_autonomous_db_metric_cpu_utilization_hourly oci_database_autonomous_db_metric_storage_utilization oci_database_autonomous_db_metric_storage_utilization_daily oci_database_autonomous_db_metric_storage_utilization_hourly oci_database_db oci_database_db_home oci_database_db_system oci_database_pluggable_database oci_database_software_image oci_dns_rrset oci_dns_tsig_key oci_dns_zone oci_events_rule oci_file_storage_file_system oci_file_storage_mount_target oci_file_storage_snapshot oci_functions_application oci_functions_function oci_identity_api_key oci_identity_auth_token oci_identity_authentication_policy oci_identity_availability_domain oci_identity_compartment oci_identity_customer_secret_key oci_identity_dynamic_group oci_identity_group oci_identity_network_source oci_identity_policy oci_identity_tag_default oci_identity_tag_namespace oci_identity_tenancy oci_identity_user oci_kms_key oci_kms_key_version oci_kms_vault oci_logging_log oci_logging_log_group oci_mysql_backup oci_mysql_channel oci_mysql_configuration oci_mysql_configuration_custom oci_mysql_db_system oci_mysql_db_system_metric_connections oci_mysql_db_system_metric_connections_daily oci_mysql_db_system_metric_connections_hourly oci_mysql_db_system_metric_cpu_utilization oci_mysql_db_system_metric_cpu_utilization_daily oci_mysql_db_system_metric_cpu_utilization_hourly oci_mysql_db_system_metric_memory_utilization oci_mysql_db_system_metric_memory_utilization_daily oci_mysql_heat_wave_cluster oci_network_firewall_firewall oci_network_firewall_policy oci_nosql_table oci_nosql_table_metric_read_throttle_count oci_nosql_table_metric_read_throttle_count_daily oci_nosql_table_metric_read_throttle_count_hourly oci_nosql_table_metric_storage_utilization oci_nosql_table_metric_storage_utilization_daily oci_nosql_table_metric_storage_utilization_hourly oci_nosql_table_metric_write_throttle_count oci_nosql_table_metric_write_throttle_count_daily oci_nosql_table_metric_write_throttle_count_hourly oci_objectstorage_bucket oci_objectstorage_object oci_ons_notification_topic oci_ons_subscription oci_queue_queue oci_region oci_resource_search oci_resourcemanager_stack oci_streaming_stream oci_vault_secret

Table: oci_core_boot_volume_metric_write_ops_daily

OCI Monitoring metrics explorer provide data about the performance of your systems. The oci_core_boot_volume_metric_write_ops_daily table provides metric statistics at 24 hour intervals for the most recent 90 days.

Examples

Basic info

select
  id,
  timestamp,
  minimum,
  maximum,
  average,
  sum,
  sample_count
from
  oci_core_boot_volume_metric_write_ops_daily
order by
  id,
  timestamp;

Intervals where volumes exceed 1000 average write ops

select
  id,
  timestamp,
  minimum,
  maximum,
  average,
  sum,
  sample_count
from
  oci_core_boot_volume_metric_write_ops_daily
where
  average > 1000
order by
  id,
  timestamp;

Intervals where volumes exceed 8000 max write ops

select
  id,
  timestamp,
  minimum,
  maximum,
  average,
  sum,
  sample_count
from
  oci_core_boot_volume_metric_write_ops_daily
where
  maximum > 8000
order by
  id,
  timestamp;

Read, Write, and Total IOPS

select
  r.id,
  r.timestamp,
  round(r.average) + round(w.average) as iops_avg,
  round(r.average) as read_ops_avg,
  round(w.average) as write_ops_avg,
  round(r.maximum) + round(w.maximum) as iops_max,
  round(r.maximum) as read_ops_max,
  round(w.maximum) as write_ops_max,
  round(r.minimum) + round(w.minimum) as iops_min,
  round(r.minimum) as read_ops_min,
  round(w.minimum) as write_ops_min
from
  oci_core_boot_volume_metric_read_ops_daily as r,
  oci_core_boot_volume_metric_write_ops_daily as w
where
  r.id = w.id
  and r.timestamp = w.timestamp
order by
  r.id,
  r.timestamp;

Query examples

blockstorage_boot_volume_top_10_write_ops_avg

Control examples

boot_volume_low_usage

.inspect oci_core_boot_volume_metric_write_ops_daily

OCI Core Boot Volume Monitoring Metrics - Write Ops (Daily)

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
average	double precision	The average of the metric values that correspond to the data point.
compartment_id	text	The ID of the compartment.
id	text	The OCID of the boot volume.
maximum	double precision	The maximum metric value for the data point.
metric_name	text	The name of the metric.
minimum	double precision	The minimum metric value for the data point.
namespace	text	The metric namespace.
region	text	The OCI region in which the resource is located.
sample_count	double precision	The number of metric values that contributed to the aggregate value of this data point.
sum	double precision	The sum of the metric values for the data point.
tenant_id	text	The OCID of the Tenant in which the resource is located.
tenant_name	text	The name of the Tenant in which the resource is located.
timestamp	timestamp with time zone	The time stamp used for the data point.
unit	text	The standard unit for the data point.