turbot/oci

GitHub
steampipe plugin install ocisteampipe plugin install oci
oci_adm_knowledge_baseoci_adm_vulnerability_auditoci_ai_anomaly_detection_ai_private_endpointoci_ai_anomaly_detection_data_assetoci_ai_anomaly_detection_modeloci_ai_anomaly_detection_projectoci_analytics_instanceoci_apigateway_apioci_application_migration_migrationoci_application_migration_sourceoci_artifacts_container_imageoci_artifacts_container_image_signatureoci_artifacts_container_repositoryoci_artifacts_generic_artifactoci_artifacts_repositoryoci_autoscaling_auto_scaling_configurationoci_autoscaling_auto_scaling_policyoci_bastion_bastionoci_bastion_sessionoci_bds_bds_instanceoci_budget_alert_ruleoci_budget_budgetoci_certificates_authority_bundleoci_certificates_management_associationoci_certificates_management_ca_bundleoci_certificates_management_certificateoci_certificates_management_certificate_authorityoci_certificates_management_certificate_authority_versionoci_certificates_management_certificate_versionoci_cloud_guard_configurationoci_cloud_guard_detector_recipeoci_cloud_guard_managed_listoci_cloud_guard_responder_recipeoci_cloud_guard_targetoci_container_instances_containeroci_container_instances_container_instanceoci_containerengine_clusteroci_core_block_volume_replicaoci_core_boot_volumeoci_core_boot_volume_attachmentoci_core_boot_volume_backupoci_core_boot_volume_metric_read_opsoci_core_boot_volume_metric_read_ops_dailyoci_core_boot_volume_metric_read_ops_hourlyoci_core_boot_volume_metric_write_opsoci_core_boot_volume_metric_write_ops_dailyoci_core_boot_volume_metric_write_ops_hourlyoci_core_boot_volume_replicaoci_core_cluster_networkoci_core_dhcp_optionsoci_core_drgoci_core_imageoci_core_image_customoci_core_instanceoci_core_instance_configurationoci_core_instance_metric_cpu_utilizationoci_core_instance_metric_cpu_utilization_dailyoci_core_instance_metric_cpu_utilization_hourlyoci_core_internet_gatewayoci_core_load_balanceroci_core_local_peering_gatewayoci_core_nat_gatewayoci_core_network_load_balanceroci_core_network_security_groupoci_core_public_ipoci_core_public_ip_pooloci_core_route_tableoci_core_security_listoci_core_service_gatewayoci_core_subnetoci_core_vcnoci_core_vnic_attachmentoci_core_volumeoci_core_volume_attachmentoci_core_volume_backupoci_core_volume_backup_policyoci_core_volume_default_backup_policyoci_core_volume_groupoci_database_autonomous_databaseoci_database_autonomous_db_metric_cpu_utilizationoci_database_autonomous_db_metric_cpu_utilization_dailyoci_database_autonomous_db_metric_cpu_utilization_hourlyoci_database_autonomous_db_metric_storage_utilizationoci_database_autonomous_db_metric_storage_utilization_dailyoci_database_autonomous_db_metric_storage_utilization_hourlyoci_database_dboci_database_db_homeoci_database_db_systemoci_database_pluggable_databaseoci_database_software_imageoci_devops_projectoci_devops_repositoryoci_dns_rrsetoci_dns_tsig_keyoci_dns_zoneoci_events_ruleoci_file_storage_file_systemoci_file_storage_mount_targetoci_file_storage_snapshotoci_functions_applicationoci_functions_functionoci_identity_api_keyoci_identity_auth_tokenoci_identity_authentication_policyoci_identity_availability_domainoci_identity_compartmentoci_identity_customer_secret_keyoci_identity_dynamic_groupoci_identity_groupoci_identity_network_sourceoci_identity_policyoci_identity_tag_defaultoci_identity_tag_namespaceoci_identity_tenancyoci_identity_useroci_kms_keyoci_kms_key_versionoci_kms_vaultoci_logging_logoci_logging_log_groupoci_logging_searchoci_mysql_backupoci_mysql_channeloci_mysql_configurationoci_mysql_configuration_customoci_mysql_db_systemoci_mysql_db_system_metric_connectionsoci_mysql_db_system_metric_connections_dailyoci_mysql_db_system_metric_connections_hourlyoci_mysql_db_system_metric_cpu_utilizationoci_mysql_db_system_metric_cpu_utilization_dailyoci_mysql_db_system_metric_cpu_utilization_hourlyoci_mysql_db_system_metric_memory_utilizationoci_mysql_db_system_metric_memory_utilization_dailyoci_mysql_heat_wave_clusteroci_network_firewall_firewalloci_network_firewall_policyoci_nosql_tableoci_nosql_table_metric_read_throttle_countoci_nosql_table_metric_read_throttle_count_dailyoci_nosql_table_metric_read_throttle_count_hourlyoci_nosql_table_metric_storage_utilizationoci_nosql_table_metric_storage_utilization_dailyoci_nosql_table_metric_storage_utilization_hourlyoci_nosql_table_metric_write_throttle_countoci_nosql_table_metric_write_throttle_count_dailyoci_nosql_table_metric_write_throttle_count_hourlyoci_objectstorage_bucketoci_objectstorage_objectoci_ons_notification_topicoci_ons_subscriptionoci_queue_queueoci_regionoci_resource_searchoci_resourcemanager_stackoci_streaming_streamoci_vault_secret

Table: oci_mysql_db_system

A DB System is a logical container for the MySQL instance. It provides an interface enabling management of tasks such as provisioning, backup and restore, monitoring, and so on. It also provides a read/write endpoint enabling you to connect to the MySQL instance using the standard protocols.

Examples

Basic info

select
id,
display_name,
lifecycle_state as state,
time_created
from
oci_mysql_db_system;

List DB systems that are not active

select
id,
display_name,
lifecycle_state as state,
time_created
from
oci_mysql_db_system
where
lifecycle_state <> 'ACTIVE';

List DB systems with backups not enabled

select
id,
display_name,
lifecycle_state as state,
time_created
from
oci_mysql_db_system
where
lifecycle_state = 'ACTIVE'
and backup_policy -> 'isEnabled' <> 'true';

List the CPU and RAM configuration of DB systems

select
id,
display_name,
lifecycle_state as state,
cpu_core_count,
memory_size_in_gbs
from
oci_mysql_db_system
where
lifecycle_state = 'ACTIVE';

Query examples

Control examples

.inspect oci_mysql_db_system

OCI MySQL DB System

NameTypeDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
analytics_clusterjsonbA summary of an Analytics Cluster.
availability_domaintextThe Availability Domain where the primary DB System should be located.
backup_policyjsonbBackupPolicy The Backup policy for the DB System.
channelsjsonbA list with a summary of all the Channels attached to the DB System.
compartment_idtextThe OCID of the compartment in Tenant in which the resource is located.
configuration_idtextThe OCID of the Configuration to be used for Instances in this DB System.
cpu_core_countbigintThe number of CPU Cores the Instance provides. These are OCPU's.
data_storage_size_in_gbsbigintInitial size of the data volume in GiBs that will be created and attached.
defined_tagsjsonbDefined tags for resource. Defined tags are set up in your tenancy by an administrator. Only users granted permission to work with the defined tags can apply them to resources.
descriptiontextUser-provided data about the DB System.
display_nametextThe user-friendly name for the DB System. It does not have to be unique.
endpointsjsonbThe network endpoints available for this DB System.
fault_domaintextThe name of the fault domain the DB System is located in.
freeform_tagsjsonbFree-form tags for resource. This tags can be applied by any user with permissions on the resource.
hostname_labeltextThe hostname for the primary endpoint of the DB System.
idtextThe OCID of the DB System.
ip_addressinetThe IP address the DB System is configured to listen on.
is_analytics_cluster_attachedbooleanIf the DB System has an Analytics Cluster attached.
is_heat_wave_cluster_attachedbooleanWhether the DB System has a HeatWave cluster attached.
lifecycle_detailstextAdditional information about the current lifecycleState.
lifecycle_statetextThe current state of the DB System.
maintenancejsonbThe Maintenance Policy for the DB System.
memory_size_in_gbsbigintThe amount of RAM the Instance provides. This is an IEC base-2 number.
mysql_versiontextName of the MySQL Version in use for the DB System.
portbigintThe port for primary endpoint of the DB System to listen on.
port_xbigintThe network port on which X Plugin listens for TCP/IP connections. This is the X Plugin equivalent of port.
regiontextThe OCI region in which the resource is located.
shape_nametextThe shape of the primary instances of the DB System.
sourcejsonbDbSystemSource Parameters detailing how to provision the initial data of the DB System.
subnet_idtextThe OCID of the subnet the DB System is associated with.
tagsjsonbA map of tags for the resource.
tenant_idtextThe OCID of the Tenant in which the resource is located.
tenant_nametextThe name of the Tenant in which the resource is located.
time_createdtimestamp with time zoneThe date and time the DB System was created.
time_updatedtimestamp with time zoneThe time the DB System was last updated.
titletextTitle of the resource.